Create a measure which by can bypass the filter brought from drill through

[Wanc]

Hello everyone,

I've designed a detailed page to display ticket statuses, specifically "success" and "failed." One of the critical metrics on this page is the percentage of failed tickets. Currently, the setup involves navigating from an overview page by right-clicking and drilling through a pie chart to select the "failed" section. This brings only "failed" tickets to the detail page, causing the denominator for calculating the percentage to consider only failed tickets.

What I'm looking to achieve is to have both "success" and "failed" tickets in the calculation. I've attempted to use functions like "removefilter" and "allselected" in the calculation, but I'm encountering issues where it either shows only failed tickets or all tickets without responding to date selection.

I'd greatly appreciate some guidance on how to address this issue.

best regards,

W

[Wanc]

Thank you for your solution.

i tried ALL before, but it has not solved my problem.

what I want to archive is - for example 20 successful tickets + 30 failed tickets for 5 application. Then I have a detail page created for failed tickets, so when I click failed -> drill through to detail page, I have a visual to show the percentage of failed ticket. However, as "failed" has been brought from the overview page, the denominator of the % always use 30 instead of 50. When i use ALL in the measure, the measure can count both success and fail but not reflect on the date range. 

best reagrds,

W

[ValtteriN]

Hi,

It sound like you are removing all the applied filters so something like CALCULATE(COUNT('table'[ticketID]),ALL('table'))

Instead:

Try using ALL to remove the filter for a specific column. E.g. CALCULATE(COUNT('table'[ticketID]),ALL('table'[ticketStatus]))

To give more detailed advice more information about your table + columns names would be required.

I hope this post helps to solve your issue and if it does consider accepting it as a solution and giving the post a thumbs up!

My LinkedIn: https://www.linkedin.com/in/n%C3%A4ttiahov-00001/