Forum Discussion

DiDiliz's avatar
DiDiliz
Frequent Visitor
1 year ago
Solved

Add multiple selectedvalues

I am trying to create a measure which will add up the separate values which are selected in the slicer.  However, because each value has a different calculation, I don't want it to add up the whole s...
Need Help
  • Angith_Nair's avatar
    Angith_Nair
    1 year ago

    Hi DiDiliz 

    Use the below dax:

    Test Measure =
SUMX(
    VALUES('TABLE1'[Week Commencing].[Month])
    CALCULATE(
        SUM('TABLE2'[Hours]) * AVERAGE('TABLE1'[Budget %]),
        FILTER(
            'TABLE1',
            'TABLE1'[Week Commencing].[Month] = EARLIER('TABLE1'[Week Commencing].[Month])
        )
    )
)
DiDiliz's avatar
DiDiliz
Frequent Visitor
1 year ago

I have now realised that I am having the same problem when filtering people with the slicers.  Rather than adding person 1 + person 2 + person 3, it's averaging the budget % over all 3 people to give the result.  Is there a way to add a second filter to the above measure to separate out people as well.  The data for people is in the same table as the months above.