Forum Discussion
Row comparison and calculation
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...
Anonymous Just to confirm, I've considered your sample data as table and performed the above measure logic which returned me 1 (As expected). Is the above screenshot of your sample data contains measures in that ?
Non, no measures added to the table.
I think I understand the problem.
As I explain on my first post, the column "valeur" come from one data table "Donnés" and the column "maxi" come from another data table called "Objectifs".
These 2 tables have common filter "Moteur" and "Designation" (Related) which could allow direct comparison between "Valeur" and "Maxi".
But as I can see, it's not really what happen, I don't know why... Maybe too complex ?