The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
For reason when I'm creating a matrix it's not returning 0 where there is blanks. Can someone help me withis?
All the relevant info is below;
The DAX to calculate the value is
Thanks
Solved! Go to Solution.
Hi,
In my opinion, if you create dimension tables for Code and Department, and then put those into the visualization, -> then the measure with +0 will work to show 0 when the result is blank.
Thanks.
@IeuanG You're likely running into AutoExist but hard to be 100% sure given the information. If you are, then the formula isn't even evaluated for combinations that AutoExist removes.
@IeuanG You're likely running into AutoExist but hard to be 100% sure given the information. If you are, then the formula isn't even evaluated for combinations that AutoExist removes.
I haven't come across AutoExist before or even knew it was a thing so I've got some reading to do! @Greg_Deckler
Hi,
In my opinion, if you create dimension tables for Code and Department, and then put those into the visualization, -> then the measure with +0 will work to show 0 when the result is blank.
Thanks.
User | Count |
---|---|
17 | |
8 | |
7 | |
6 | |
6 |
User | Count |
---|---|
27 | |
13 | |
12 | |
9 | |
8 |