Forum Discussion
Row comparison and calculation
Hi community, I have 2 tables : the first one contains data measured (named "Valeur" below) and another one contains the max limit (named "Maxi" below). What I need is : 1) Do a comparison betw...
PattemManohar
Community Champion
Community ChampionAnonymous I hope you are looking for something like this...
Please try this as a New Measure
Test290 = CALCULATE(DISTINCTCOUNT(Test290Measure[Designation]),FILTER(Test290Measure,Test290Measure[Value]>Test290Measure[MaxValue]))
Hello PattemManohar , thanks for your answer.
It was my first idea but unfortunately it didn't work.
First of all, we must add an agregation for the comparison to be validated by editor
> Min(Test290Measure[Maxvalue]
Then, by agregation MIN, PBI only considers the value 0.5 and compare it with the 3 others value (1.0 , 2.0 and 0.0) instead of comparing 3 times (for the 3 measures) Maxi and Valeur (1.0>1.5? 2.0>0.5? 0.0>2.0?)
So PBI return 2 (cause it see 1.0 and 2.0 are > 0.5) instead of resulting 1 (only 2.0>0.5).
Hope you understand my issue...