Sam_2020Helper I6 years agoSolvedMeasure 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 Show Moreryan_mayu to Sam_20206 years agoSam_2020 for the second scenario,please try thisMeasure = VAR _value=SELECTEDVALUE('Table'[SALES]) return IF(_value>100,_value,SUMX(FILTER('Table','Table'[SALES]>60),'Table'[SALES]))
ryan_mayu to Sam_20206 years agoSam_2020 for the second scenario,please try thisMeasure = VAR _value=SELECTEDVALUE('Table'[SALES]) return IF(_value>100,_value,SUMX(FILTER('Table','Table'[SALES]>60),'Table'[SALES]))
ryan_mayu to Sam_20206 years agoSam_2020 for the second scenario,please try thisMeasure = VAR _value=SELECTEDVALUE('Table'[SALES]) return IF(_value>100,_value,SUMX(FILTER('Table','Table'[SALES]>60),'Table'[SALES]))
kkandaResolver II to ryan_mayu6 years agoThis question was answered by Nemanja.Thanks for all responses.
