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?
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.
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.
Please share some dummy data in source table and show us the formula of the measure which is displayed in card visual.