Forum Discussion

rmeng's avatar
rmeng
Icon for Helper II rankHelper II
4 years ago
Solved

Calculate quarter data based on a month selection

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.

 

Need Help
  • Fowmy's avatar
    Fowmy
    4 years ago

    rmeng 

    Use the following measure:

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

1 Reply

  • Fowmy's avatar
    Fowmy
    Icon for Super User rankSuper User
    4 years ago

    rmeng 

    Use the following measure:

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