Forum Discussion

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

6 years ago

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

Helper I

6 years ago

Thanks Namaja for your reply.

If I have other product which are >60, then how should i write the measure?

Super User

6 years ago

Please try this

Measure = IF(SELECTEDVALUE('Table'[SALES])=100,100,SUMX(FILTER('Table','Table'[SALES]=100),'Table'[SALES]))