Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello,
I'm using a matrix with a dimension as rows:
Counts | Position | TotalRevenue | ||
Post | ||||
Direct | 50 | 3 | 1000 | |
Total |
I know using If-statements or adding a "+0" in a count measure can solve this problem, but I try to stick with
the standard aggregation function for the tables without an extra mesaure. When PowerBi recognized it as a Number- Datatype I already have plenty of aggregation for selection. Here depending on column I used count or sum . In the row properties I already clicked that it should show also empty values. But as you see its blank instead of zero.
Is it possible without a extra measure to change it?
Thank you very much in advance.
Solved! Go to Solution.
HI @Applicable88,
In fact, 'if statement' and '+0' on the expression not work to handle records that not really existed in your table.
For this scenario, you need to create a not connected to the raw table and use its fields to replace raw table categories. Then you can use Dax expression to extract the current data and compare it with if statements.
Regards,
Xiaoxin Sheng
HI @Applicable88,
In fact, 'if statement' and '+0' on the expression not work to handle records that not really existed in your table.
For this scenario, you need to create a not connected to the raw table and use its fields to replace raw table categories. Then you can use Dax expression to extract the current data and compare it with if statements.
Regards,
Xiaoxin Sheng
Nope. Blanks and zeros are not the same. You'll need measure(s) to do the conversion.
No, it is not possible to show 0 instead of blank using the default aggregations.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
99 | |
83 | |
70 | |
61 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |