Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

DISTINCTCOUNT values difference between AXIS visual and card visual

Hello, guys! I need some help over here, if you could so, I appreciate.   I'm using a DISTINCTCOUNT to get the distinct values from column A applying this measure to a Card, but when I apply to a ...
Need Help
  • camargos88's avatar
    camargos88
    6 years ago

    Anonymous ,

     

    Perhaps if you get the first or last value per order, would it work ?

     

    Check this file: Download PBIX 

     

    Ricardo

camargos88's avatar
camargos88
Icon for Community Champion rankCommunity Champion
6 years ago

Hi Anonymous ,

 

Have you noticed you have Ordens with more than 1 situation ?

 

 

On your clustered chart, it shows 12 duplicated values.

 

Ricardo

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi, camargos88

 

Yep. I know that.

The point is to do the total of column chart be equal the card.

 

I was trying to do a distinct one that ignore this "situation" thing and only count all distinct orders independent where it is (where is the context).

 

I don't even know if this will work fully.. but I wanna give a try before use a new dataset without these double orders.

(The original dataset came from my company and run by invoice (first-level criterial) and not by orders, so if I've to change it.. it'll take a while. And I don't wanna it).

 

Anyway, thanks for your help!

  • camargos88's avatar
    camargos88
    Icon for Community Champion rankCommunity Champion
    6 years ago

    Anonymous ,

     

    Perhaps if you get the first or last value per order, would it work ?

     

    Check this file: Download PBIX 

     

    Ricardo

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      That's it! The "_First" worked perfectly!

      Thanks for your help, camargos88 !

       

      Willian Victor