Forum Discussion

mizaskun's avatar
mizaskun
Icon for Helper II rankHelper II
5 years ago
Solved

Modify measures depending on filters

Good morning,   I have a very simple model:   User Type Amount A Z 100 A Z 200 A Y 50   I created the following measure: TotalByUser = calculate( sum(Table[Amount]), all...
DAX
Filtering
Measures
  • daxer-almighty's avatar
    daxer-almighty
    5 years ago
    TotalByUser =
CALCULATE(
    SUM( Table[Amount] ),
    VALUES( Table[User] ),
    ALLSELECTED( 'Table' )
)

    It might be that the above does what you want...

daxer-almighty's avatar
daxer-almighty
Icon for Solution Sage rankSolution Sage
5 years ago

mizaskun 

 

If your model is much different from what you show here, then it'll be very hard to give you a good solution.

 

But even if you do show the right model, I'd recommend you first read this: Using ALLEXCEPT versus ALL and VALUES - SQLBI

 

It may explain why you see what you see.

mizaskun's avatar
mizaskun
Icon for Helper II rankHelper II
5 years ago

Thank you so much. I will.