Forum Discussion

Sam_2020's avatar
Sam_2020
Helper I
6 years ago
Solved

Measure

How to write measure of the column header with Sales > 60 and the total value is 100?   Product Sales Sales > 60 A 100 100 B 30   C 50   Total 180 100
Need Help
  • ryan_mayu's avatar
    ryan_mayu
    6 years ago

    Sam_2020 

    for the second scenario,

    please try this

    Measure = 
VAR _value=SELECTEDVALUE('Table'[SALES])
return IF(_value>100,_value,SUMX(FILTER('Table','Table'[SALES]>60),'Table'[SALES]))

Sam_2020's avatar
Sam_2020
Helper I
6 years ago

Thanks. 

 

It works perfectly.

 

Are you able to explain "return IF(_value>100;_value;"?

 

Do I need to look the highest value and indicate in my measure?