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
Month: February 2022
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
What is the Difference Between INNER JOIN, LEFT JOIN, RIGHT JOIN and FULL JOIN?
There are different types of joins available in SQL: INNER JOIN: returns rows when there is a match in both tables. LEFT JOIN: returns all rows from the left table, even if there are no matches in the right table. RIGHT JOIN: returns all rows from the right table, even if there are no matches Read More