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

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.