Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Distinct Count table working but not Card

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?

 

Need Help

4 Replies

  • richbenmintz's avatar
    richbenmintz
    Resident Rockstar
    7 years ago

    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. 

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    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.  

  • v-yulgu-msft's avatar
    v-yulgu-msft
    Microsoft Employee
    7 years ago

    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