Forum Discussion

DiDiliz's avatar
DiDiliz
Frequent Visitor
1 year ago
Solved

Separate measure by multiple slicer options

I am trying to create a measure that performs a calculation but adds together the value of the measure when multiple options are selected in the slicer instead of adding everything together.  So for ...
Need Help
  • johnt75's avatar
    johnt75
    1 year ago

    I think you can use

    My Measure =
SUMX (
    SUMMARIZE ( Table1, Table1[WeekCommencing].[Month], Table1[TeamMember] ),
    CALCULATE ( SUM ( 'TABLE2'[Hours] ) * AVERAGE ( 'TABLE1'[Budget %] ) )
)
johnt75's avatar
johnt75
Icon for Super User rankSuper User
1 year ago

I think you can use

My Measure =
SUMX (
    SUMMARIZE ( Table1, Table1[WeekCommencing].[Month], Table1[TeamMember] ),
    CALCULATE ( SUM ( 'TABLE2'[Hours] ) * AVERAGE ( 'TABLE1'[Budget %] ) )
)
DiDiliz's avatar
DiDiliz
Frequent Visitor
1 year ago

That's worked great, thanks