How to write measure of the column header with Sales > 60 and the total value is 100? ProductSalesSales > 60A100100B30 C50 Total180100

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

Measure | Microsoft Fabric Community

11 Replies

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
  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
    Resident Rockstar
    6 years ago
    Hi kkanda ,
    By mistake i tagged you on this question.
    I also now answered on your question 🙂
- Sam_2020
  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?
  
  Product Sales Sales > 60
  A 100 100
  B 30
  C 50
  D 75 75
  E 90 90
  Total 345 265
  - ryan_mayu
    Super User
    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]))