You probably know that the ISFILTERED function returns TRUE when the specified table or column is being filtered directly. But did you know that if you add multiple ISFILTEREDs together, ISFILTERED will not return true or false, but will return a number. You can combine this returned number with a switch function to influence your total levels.

To quote the explanation of Microsoft: When you are filtering multiple columns on the same table, the current default value filter behavior takes these filters and combines them into one, considering only the combinations that exist…

if you use a semicolon (;) between folder structures, you can show that measure in multiple folders…

Example: Only customer A needs to be visible. To be able to see only customer A, you can use the expression FILTER or KEEPFILTERS. Both

The CALCULATE expression is perhaps the most important expression in the DAX library. The CALCULATE expression can be used to modify existing filter context or

The X stands for iteration expression. Iteration means that Power BI will no longer calculate the total or max of a single column but will

There is a data model. This data model consists of one (1) dimension table and three (3) fact tables. Each fact table consists of one

If you use an ALL function on a column that has a sorting by column applied, you also need to take that sorting column into

You can format all your DAX measures at once. No more single-handed formatting every measure one by one. To format all your measures at once