Forum Discussion

melikekurrt's avatar
melikekurrt
Frequent Visitor
1 year ago
Solved

Power BI - multiple filtering

Hello, I am analyzing the SLA status of the tickets. But I am experiencing inconsistency. What I want to do is to filter and list the openperiod and close period dates at the same time. I'm new to P...
  • Anonymous's avatar
    Anonymous
    1 year ago

    Hi melikekurrt ,

    Please try this way:
    Here is my sample data:

    Use Numeric range parameter to create another table for slicer:

    The minimum and maximum values here correspond to the minimum and maximum values of fxPeriod in your original data, respectively.

    Then use this DAX to create a measure:

    Filter = 
    VAR _fxPeriod = SELECTEDVALUE(fxPeriod[Parameter])
    RETURN
    IF(
        ISFILTERED(fxPeriod[Parameter]),
            IF(
                MAX('Table'[fxClosedPeriod]) = _fxPeriod || MAX('Table'[fxOpenPeriod]) = _fxPeriod,
                1,
                0
            ),
        1
    )

    Set up the filter as shown below:

     

     Output:


    Best Regards,
    Dino Tao
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.