Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Handling duplicates in IF statements

Hello   I write a MEASURE = IF(Table1[Col1]="SOMETHING",.....   However, it seems that because there are duplicate values in Table1[Col1], the MEASURE does not work.   This is not a behaviour I...
Need Help
  • v-eachen-msft's avatar
    v-eachen-msft
    6 years ago

    Hi Anonymous ,

     

    Measure is different with calculated column, you need to use MAX(), MIN(), SELECTEDVALUE() or other functions to get a single value (aggregation) for calculation and comparison.

     

v-eachen-msft's avatar
v-eachen-msft
Icon for Community Support rankCommunity Support
6 years ago

Hi Anonymous ,

 

Measure is different with calculated column, you need to use MAX(), MIN(), SELECTEDVALUE() or other functions to get a single value (aggregation) for calculation and comparison.