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

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

Hi,

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

thanks,

Cosmin

  • jdbuchanan71's avatar
    jdbuchanan71
    Super User
    7 years ago

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

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