Forum Discussion

Boudewijn's avatar
Boudewijn
Frequent Visitor
7 years ago
Solved

Slicer filter another slicer

Power BI Set up; - 1 Table - Slicer 1 (Between) for column A (Values) - Slicer 2 (Between) for column B (Date)   Goal: [Count values filtered by slicer 1 and slicer 2] divided by [Count Values ...
Need Help
  • v-juanli-msft's avatar
    v-juanli-msft
    7 years ago

    Hi Boudewijn

    in my test, 

    [Count values filtered by slicer 1 and slicer 2] ---Measure

    divided by

    [Count Values filtered only by slicer 2]    ---------Measure 2

     

    Best Regards

    Maggie

     

v-juanli-msft's avatar
v-juanli-msft
Icon for Community Support rankCommunity Support
7 years ago

Hi Boudewijn

Create a date table 

New table-> enter the following formula

Table = CALENDARAUTO()

leave no relationship between this date table and your table

 

Create measures

MIN = MIN('Table'[Date])

Max = MAX('Table'[Date])

Measure =
CALCULATE (
    COUNT ( Sheet3[index] ),
    FILTER ( ALLSELECTED ( Sheet3 ), [columnB] >= [MIN] && [columnB] <= [Max] )
)

Measure 2 =
CALCULATE (
    COUNT ( Sheet3[index] ),
    FILTER ( ALL ( Sheet3 ), [columnB] <= [Max] && [columnB] >= [MIN] )
)

 

Best Regards

Maggie

 

Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.