Backgrounds A bit of context – I have a dataset with a date table and a table which is a list of ‘Tickets issued’. They are linked via Issued Date. I am trying to get the average number of tickets Issued a week, for each location (tickets have the location that they were issued to). Read More
Category: Power BI
ALL vs. ALLSELECTED in DAX
ALL vs. ALLSELECTED DAX functions The biggest difference between ALL and ALLSELECTED is that the ALL function ignores all filters, regardless of where they are coming from. In contrast, the ALLSELECTED function only ignores filters that are coming from the inner query. Returning Total Sales of all Selected Countries The following expression in DAX would return the Read More
How to Split a Column with Multiple Values into Rows (Excel)
I have received some sales data from John, my favourite imaginary salesperson. He’s decided to merge some of his data. I have a list of companies on each line, instead of one row for each company. I want to have one row per company so that I can link to other company data. I start Read More
How to Import Data from JSON Files and Rest APIs into Power BI
by Ben Richardson In this article, you will see how to import data from JSON files and Power BI Rest API into the Power BI environment. Power BI is a Microsoft application for data analytics and visualization. With Power BI, you can create interactive data visualizations without writing a single line of code. To create a Read More
COUNTROWS vs COUNT vs COUNTA
As a data modeler, sometimes you might need to write a DAX expression that counts table rows. The table could be a model table or an expression that returns a table. Your requirement can be achieved in two ways. You can use the COUNT function to count column values, or you can use the COUNTROWS function to count table Read More
How to Change Power BI Report Page Size
Did you know you can adjust the page size of your reports in Power BI? Each tab/page of your report can be a unique size specified by you down to the pixel. This comes in handy for creating “widget-like” visuals for embedding or for creating reports for print and optimal display on various screen sizes. Read More