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.

     

parry2k's avatar
parry2k
Icon for Super User rankSuper User
6 years ago

Anonymous you need to understand the difference between columns and measures, if you are creating a measure, you have to use some sort of aggregation and in this case, MAX is used as aggregation function.

 

https://www.sqlbi.com/articles/calculated-columns-and-measures-in-dax/

 

I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!

⚡Visit us at https://perytus.com, your one-stop shop for Power BI related projects/training/consultancy.⚡