cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
rranieri Regular Visitor
Regular Visitor

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?

 

DistinctValues.png

4 REPLIES 4
rafaelmpsantos Established Member
Established Member

Re: Distinct Count table working but not Card

Show us the measure created and put into card

richbenmintz
Advisor

Re: Distinct Count table working but not Card

Hi @rranieri,

 

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. 

Nick_M Senior Member
Senior Member

Re: Distinct Count table working but not Card

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.  

Community Support Team
Community Support Team

Re: Distinct Count table working but not Card

Hi @rranieri,

 

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

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.