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 Nemanja,  thanks for the response. I am not looking for the MAX value. What I am looking for is creation of a measure by the simple clicking on any bar - that becomes my selected category. If I get that category name as a new measure, I want to create another chart detailing the sales trend of that category over a period of time. Maybe this is wishful thinking - the experts can give their opinion.

kkanda

nandic's avatar
nandic
Resident Rockstar
6 years ago

Hi kkanda ,

By mistake i tagged you on this question.
I also now answered on your question 🙂