cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
WillianVictor
Frequent Visitor

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 Clustered Column Chart, this doesn't working fully.

 

If you sum the values from the Column Chart the total will be different.

Like this (the number format from the visuals is from Brazil, so dot is comma and comma is dot):

MyMeasure = DISTINCTCOUNT(Table1[ColumnA])

x.PNG

Let's add up the values from column chart:

4520+488+108+99+23+1 =5239

 

How can you see, the total values is different between Card and Column Chart distributed by AXIS labels.

 

The question is: how could I use the same total from Card applied to the Column Chart?

 

Bellow samples of my dataset and PBIX to make it more easy to understand.

Dataset

https://drive.google.com/open?id=1Mhg0QPpPxTPxmo_q2OYYwLn4xbiV47J1

PBIX

https://drive.google.com/open?id=1IPeK7j5uDWIU2517T8D_7l6Lh5nmCtmh

 

 

Best

Willian Victor

1 ACCEPTED SOLUTION

@WillianVictor ,

 

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

 

Check this file: Download PBIX 

 

Ricardo



Did I answer your question? Mark my post as a solution!

Proud to be a Super User!



View solution in original post

4 REPLIES 4
camargos88
Super User III
Super User III

Hi @WillianVictor ,

 

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

 

Capture.PNG

 

On your clustered chart, it shows 12 duplicated values.

 

Ricardo



Did I answer your question? Mark my post as a solution!

Proud to be a Super User!



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!

@WillianVictor ,

 

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

 

Check this file: Download PBIX 

 

Ricardo



Did I answer your question? Mark my post as a solution!

Proud to be a Super User!



View solution in original post

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

Thanks for your help, @camargos88 !

 

Willian Victor

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

April Update

Check it Out!

Click here to read more about the April 2021 Updates!

secondImage

The largest Power BI virtual conference

100+ sessions, 100+ speakers, Product managers, MVPs, and experts. All about Power BI. Attend online or watch the recordings.

secondImage

Experience what’s next for Power BI

See the latest Power BI innovations, updates, and demos from the Microsoft Business Applications Launch Event.

Top Solution Authors