With a very simple DAX expression, you can yourself create a measure adding a ‘0’ to the formula, meaning you will never have to see ‘blank’ again. However, a more natural way to display ‘no revenue’ should be ‘0’ instead of ‘blank’. When displaying numerical data in a card, for example ‘revenue’, it will return ‘blank’ if you set your filters in a way there is no revenue to show. A very simple example of this is the ‘blank’ value in the card widget. Once you know how to use DAX you will be surprised at how many of these headaches you can avoid, or completely bypass (in some hacky way).
It doesn’t take a lot of experience to reach a point where you are cursing at your screen, because your dashboard does not give you the results you expected. This means that the dashboard can take input from the users and use it to dynamically generate calculated columns, measures and tables. The most import feature you will unlock is being able to select, join, filter,… data in a dynamic way. That being said, learning DAX will open up a new world of Power BI for you. However, this comparison is not completely valid since, or at least in my opinion, Power BI is already an incredibly powerful tool even without DAX, as in contrast, anything beyond light use in Excel already requires formulas. Learning DAX as a Power BI user is much like being an Excel user and discovering how to use formulas, You were able to structure your tables, add some charts and click the sum/average/… button (Σ) but suddenly you discover the world of VLOOKUP, IF functions and whatnot.
Writing DAX in Power BI (image source: ) Why You Should Learn DAX
0 kommentar(er)
