Forum Discussion

DorisCMoore's avatar
DorisCMoore
Frequent Visitor
3 years ago
Solved

How to dynamically modify a Measure result based on a specific value?

Hello,   I'm trying to create a Measure, which calculation should be dynamically impacted based on a column value.   To illustrate, here's the "default" mesure I'm using: Measure = CALCULATE(sum...
Need Help
  • andhiii079845's avatar
    andhiii079845
    3 years ago

    In which context do you want your measure? Can you please make this more clear for me, please?
    You can try this:

    Measure = IF(MAX('Table'[Wi])="Bug",CALCULATE(sum('Table'[Effort]),'Table'[State]="Done")+100,CALCULATE(sum('Table'[Effort]),'Table'[State]="Done"))
     
    Be aware of the measure you use sum instead of sumx.