sample csv file

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

sample csv file

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

sample csv file

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

sample csv file

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

sample csv file

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