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 Power BI I need help

 

For example, here in the filter section, I am listing the sla breach tickets that were closed in week 37. I also want to add the tickets that were opened in week 37 and received sla to the list. Because some tickets may not have been closed yet, I am missing the essence due to the close date period filter. What can I do ?

 

 

 

Thank you,

 

 

 

General Comment
  • 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.

2 Replies

  • lbendlin's avatar
    lbendlin
    Super User
    1 year ago

    Does your data model have a Calendar table?  Are your slicers fed by disconnected tables or from the data model?

     

    Lutfen, provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).

    Do not include sensitive information. Do not include anything that is unrelated to the issue or question.

    Need help uploading data? https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216

    Please show the expected outcome based on the sample data you provided.

    Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523

  • Anonymous's avatar
    Anonymous
    Not applicable
    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.