Forum Discussion
different value in different visuals
Hi, Faber13 ;
I create a simple file like below:
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?
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"
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)
