Forum Discussion

ArchStanton's avatar
ArchStanton
Power Participant
2 years ago

Page Filters and Measure Interaction

 

Hi,

 

I have the following measure that works perfectly.

YTD Closed Cases 2 = CALCULATE(
    TOTALYTD(COUNT('Closed Cases'[Case Number]),
        'Closed Cases'[Resolution Date],"31/03"),
            'Closed Cases'[statecode] = "Resolved")

 

I have a filter on all of my pages that excludes Team A, however I've just noticed that when I remove other Teams from the Filter (Team B & Team C)  nothing changes in the visual - the numbers stay the same.
Is this normal behaviour?


I've seen some DAX videos where using KEEPFILTERS / REMOVEFILTERS can make a difference to the totals but so far I haven't been able to assign these Functions correctly to the code above.

Can anyone suggest where in the code I could use these function that would allow the measure to ignore the filter on the page?
Thanks



Need Help
Show and Tell

1 Reply

  • Sahir_Maharaj's avatar
    Sahir_Maharaj
    Super User
    2 years ago

    Hello ArchStanton,

     

    Can you please try the following:

    YTD Closed Cases 2 = 
CALCULATE(
    TOTALYTD(
        COUNT('Closed Cases'[Case Number]),
        'Closed Cases'[Resolution Date], 
        "31/03"
    ),
    'Closed Cases'[statecode] = "Resolved",
    REMOVEFILTERS('Closed Cases'[Team])
)