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

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
5 years ago

mizaskun , Try a measure like

 

sumx(values(Table[User]) ,if(isfiltered(Table[Type]) , calculate(sum(Table[Amount])), calculate( sum(Table[Amount]), allexcept(Table, Table[User]))))

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

    Good morning,

     

    Thank you for your answer! The model actually have much more fields through which can be filtered. The table I explained was a simplification to make it easier to understand what I need. There should be a way to achieve that behavour. 

     

    Thank you so much! 

    • daxer-almighty's avatar
      daxer-almighty
      Icon for Solution Sage rankSolution Sage
      5 years ago
      TotalByUser =
CALCULATE(
    SUM( Table[Amount] ),
    VALUES( Table[User] ),
    ALLSELECTED( 'Table' )
)

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