Calculate quarter data based on a month selection

[rmeng]

I need help to build a card or a table value when a month is filtered to show the value of all quarter not only the month selected.

when I select 2021 September I need the September value that´s easy and correct but for Quarter 3 I need a value summing all 3 months of that quarter.

[Fowmy · Accepted solution]

@rmeng 

Use the following measure:

Event Quarter = 
CALCULATE(
    [# Events],
    REMOVEFILTERS('Calendar'[Year Month]),
    VALUES('Calendar'[Year Qtr]])
)