Create a dax measurement for percentage that reflects correctly in a visual when drilling down data

[Anonymous]

Case Type

Case #

Case ID

Case Style

Date Filed

Age of case

Next Hearing date

Case Status

Case Category

Case Status Date

Court

Count

Age of case - groups

Misd

XXX

XXX

XXX

8/30/2023

111

Null

Filed

CR

8/30/2023

CCL3

3

91-120

Misd

XXX

XXX

XXX

11/30/2022

384

Null

Filed

CR

11/30/2022

CCL3

3

361+

Misd

XXX

XXX

XXX

8/15/2023

126

Null

Filed

CR

8/15/2023

CCL3

3

121-180

I have created a tooltip using the following dax measurements for a "card" visual:

1st Measurement:  Total Rows = COUNTROWS('County Courts Pending v12 - Grouped by Case ID')

2nd Measurement: % of Total = DIVIDE([TOTAL ROWS], CALCULATE([TOTAL ROWS], ALL ('County Courts Pending V12 - Grouped by Case ID'[COURT])))

When using the tooltip on a "stacked bar chart" visual (created to indicate the number of pending cases by Court), the percentage reflects correctly based on the current "Total Pending Cases" amount.  However, when I choose to "Drill down" on one of the "Courts" of the "stacked bar chart" visual, the "Total Pending Cases" changes as expected for the particular Court but, the percentage does not calculate correctly.  The percentage is far less than expected, for the total pending case for that Court. 

This is the tooltip that was created.

Tooltip - Canvas with measurement

The tooltip reflects the correct % for the 11,652 Grand total currently reflecting, for County Court at Law 1.

All Courts - Percentage calculates correctly

A "drill down" is performed for a specific court, ex.  County Court at Law 1

Drill down - Ex. County Court At Law 1

The Total Pending cases amount adjusts, but the percentage amount is incorrect, it should be 84% of the 800 total pending cases.

I am in need of assistance to create a measurement that will allow for the percentage to reflect correctly based on the changed data that occurs when a  "drill down"  occurs for a visual, please.

[Greg_Deckler]

@Anonymous Sorry, having trouble following, can you post sample data as text and expected output?
Not really enough information to go on, please first check if your issue is a common issue listed here: https://community.powerbi.com/t5/Community-Blog/Before-You-Post-Read-This/ba-p/1116882

Also, please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

The most important parts are:
1. Sample data as text, use the table tool in the editing bar
2. Expected output from sample data
3. Explanation in words of how to get from 1. to 2.

[Anonymous]

Thank you for the additional information.  As a new user to Power BI, I apologize in advance if I miscommunicate the information, any help is greatly appreciated.