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