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]))

kkanda's avatar
kkanda
Resolver II
6 years ago

Hello All,

My question was diffrent and I do not know how it got clubbed with another query. 

This question is still open and there is no accepted solution. 

Will you please remove the "ACCEPTED SOLUTION" from my original post, so that others will look at it?

Thanks

kkanda

 

ryan_mayu's avatar
ryan_mayu
Super User
6 years ago

kkanda 

Please share your post link or create a new post

.

  • kkanda's avatar
    kkanda
    Resolver II
    6 years ago

    This question was answered by Nemanja.

    Thanks for all responses.