Forum Discussion

cosminc's avatar
cosminc
Post Partisan
7 years ago
Solved

Filter Context

Hi all the filters applied on page level are considered as Filter Context and can be overwritten on a calculate dax expression? Thanks, Cosmin
Need Help
  • jdbuchanan71's avatar
    jdbuchanan71
    7 years ago

    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")

     

jdbuchanan71's avatar
jdbuchanan71
Super User
7 years ago

Give this a try cosminc 

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

 

cosminc's avatar
cosminc
Post Partisan
7 years ago

thanks

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

 

  • jdbuchanan71's avatar
    jdbuchanan71
    Super User
    7 years ago

    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's avatar
      cosminc
      Post Partisan
      7 years ago

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

      • jdbuchanan71's avatar
        jdbuchanan71
        Super User
        7 years ago

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