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

nandic's avatar
nandic
Resident Rockstar
6 years ago

Hi Sam_2020  ,
If purpose is to display only max value and to display same value in total, below is formula:

Max Value = IF(MAX(Sheet1[Sales]) = CALCULATE(MAX(Sheet1[Sales]),ALL(Sheet1[Product])),MAX(Sheet1[Sales]))
 


Cheers,
Nemanja
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 🙂

  • 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.