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.
I am trying to make a card visualization of the discintct count of materials that I have that have no sales (net billing is zero). I made sure to have no filters whatsoever on this page. The distict count of materials when viewed as a table gives me 3004 while a card visualization of the distinct count of materials gives me 3383.
Is there any way I can get the card value to give the correct amount?
Hi @Anonymous,
Please share some dummy data in source table and show us the formula of the measure which is displayed in card visual.
Regards,
Yuliana Gu
Do you happend to have an idea which ones if probably correct?
Also, in your measure was the filter set to " Net Billion =0"? If so, could be a situation where there may be blanks which may or may not be affecting this situation.
Another thing to remember is the table in itself has a filter context. Just throwing some ideas out there, but if you can provide some more info, I'm sure we can figure it out.
Hi @Anonymous,
Are you able to share your .pbix file? It is hard to help with this problem without seeing the data and the measures. One thing to consider is that distinct counts are not always additive, so the value in a table with multiple rows may be different than the distinct count over the whole set like a card visual.
Proud to be a Super User!
Show us the measure created and put into card
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 |
---|---|
109 | |
98 | |
80 | |
64 | |
57 |
User | Count |
---|---|
145 | |
110 | |
91 | |
84 | |
66 |