Filter Context

[cosminc]

Hi all

the filters applied on page level are considered as Filter Context and can be overwritten on a calculate dax expression?

Thanks,

Cosmin

[jdbuchanan71]

Hello @cosminc ,

That is correct.  In the example below the ALL ( Dates ) portion of the measure clears the filter on Year Month that is set on the page.

[cosminc]

Hi,

so i can't create a Calculate with filter 1 feb, right?

thanks,

Cosmin

[jdbuchanan71]

No sure I understand.  You can create a measure that calculates the amount for Feb, ignoring the filter on the page.

Count Status Feb = 
CALCULATE(
    [Count Status],
    ALL ( Dates ),
    Dates[Year Month] = "Feb-2019"
)

[cosminc]

do i miss something?

https://drive.google.com/file/d/1rUvtYmgZY3o6mmqZ7NXP6LiZrIdmD7t9/view

measure Funnel Rate - return all sample 

expected result 

Label     Funnel Rate

B                 4

C                 4

D                 4

Z                 4

where 4 is count of A from the source

Thanks,

Cosmin

[jdbuchanan71]

Give this a try @cosminc 

Funnel Rate = 
CALCULATE(
    COUNTROWS(Source_full),
    ALL(Source_full),
    Source_full[Label] = "A"
)

 

[cosminc]

thanks

it freezes any slicer...i need to be interactive with all slicers

[jdbuchanan71]

Doesn't your first measure do that?  I thought you wanted all "A" regardless of other filters which is what my measure does.  What should your example look like with a filter applied and what is that specific filter.  What should the table look like if you pick Client = 'cosmin'?

[cosminc]

no, the first measure doesn't put result of A (=4) on each listed Labels in graph

[jdbuchanan71]

That is what my measure returns.  What should the table look like if you pick Client = 'cosmin'?

[cosminc]

B    2

C    2

D    2

Z    2

[jdbuchanan71 · Accepted solution]

So you will need to modify the measure to use ALLEXCEPT and list the columns you would still like to be able to use in the slicers.  The measure below will respect selections on the Client, Slicer1, Slicer2 and Slicer3 columns

Funnel  Rate = 
CALCULATE(
    COUNTROWS(Source_full),
    ALLEXCEPT(
        Source_full,
        Source_full[Client],
        Source_full[Slicer1],
        Source_full[Slicer2],
        Source_full[Slicer3]
    ),
    Source_full[Label] = "A")

[cosminc]

Thanks for your help!

Cosmin