Forum Discussion
Faber13
Helper II
Helper IIdifferent 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? ...
PabloDeheza
Solution Sage
Solution SageThe 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.
Faber13Helper II
Helper IIPabloDeheza 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)