Forum Discussion
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? ...
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!
