Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Faber13
Helper II
Helper II

different value in different visuals

I have a measure that has the correct total value, when I put it in a table it keeps the correct value in the total, when I break it in it changes the value, do you know what it can be?

 

Faber13_0-1669399180540.png

 

 

Faber13_1-1669399206460.png

 

6 REPLIES 6
v-yalanwu-msft
Community Support
Community Support

Hi, @Faber13 ;

I create a simple file like below:

vyalanwumsft_0-1669604610449.png

And Created visual, however For my simple example, I am not very clear, you want the output of the result, or can you create a simple example and hope to output the result display? 

vyalanwumsft_1-1669604627197.png

Solved: How to upload PBI in Community - Microsoft Power BI Community


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

 

in my example, I need the total value breakdown to be 37,669 which is the correct value, the relationship is active for the column I'm using in the measure, I tried using "USERELATIONSHIP"

 

 

Faber13_0-1669631263032.png

 

The correct values is 37,669 fot the total, but not for the breakdown as you might have the same nfs in different periods so it will count one nfs per each. On the other hand, your total will do a DISTINCT over nfs before counting them, so if you previously had the same nfs, one on each perdiod, for your total it will only count as 1, thats why your total is always displaying a lower value that the sum of each period.

@PabloDeheza  that might be it, would you know how to calculate only these repeated values ​​and then leave only the last values ​​(of the repeated ones)

PabloDeheza
Solution Sage
Solution Sage

Hi @Faber13 !
In your measure you are using DISTINCTCOUT(), which for each of the categories is counting the distinct values, the this is that for your total is its doing the same thing, so it will remove the duplicates that you may have between the categories. In other words, if one [Nota fiscal] is in both Meio do mes and Fim do mes, in your total will count as one.

If your goal is to sum the values of your categories to show that in the total then try the following:

SUMX( Values( Periodo Mes), [Nfs Distintas] )

Let me know if that helps!

@PabloDeheza  still with the same error

 

 

Faber13_0-1669401946342.png

 

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.