Power BI - multiple filtering

[melikekurrt]

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,

[Anonymous · Accepted solution]

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.

[lbendlin]

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-...

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/1447...