Percent of filter total to the unfilter total

[djones1855]

I have a simple matrix a Row value for "States" and two values.  The first being a Count values in the "Claim Number" column and the another count of values in the "Claim Number" but shown as a percentage.  When no "Result filter is being applied it shows me the values that I want with a total claim value count of 10,285. 

When I apply the Result filter of "Decreased" the Claim Count is reduced to 2,277, which is fine, but I would like the percentage to still be calculated against the full count total of 10,285 not the filtered count total of 2,277.

Any suggestions? 

[Anonymous · Accepted solution]

Hi! I believe you should write a measure for your percent of grand total with an ALL function

Something like

Measure = calculate(divide(sum(total claims), calculate(sum(total claims), all(claim_type))

Then use modeling to format as a percentage. Make sure to read the DAX documentation on ALL and VALUES as I think it would be helpful. I would post the links, but am on mobile rn. Hope that is helpful.

[v-yiruan-msft · Accepted solution]

Hi @djones1855，

You can create the below measure  with ALL function to calculate full totals of claim number, it will ignore any filter that might be applied when using this function:

1. Calculate the full total claim number

          ftotalClaimNum= CALCULATE( SUM(totalClaimnumber), ALL(Result))

1. Calculate percentage

          %GT Count of Claim Number =DIVIDE( CALCULATE( SUM(totalClaimnumber)), ftotalClaimNum)

You can refer this documentation for the details of ALL function.

If the above measures are not applicable in your scenario, please provide the related table structure and sample data.

Best Regards

Rena

[Anonymous · Accepted solution]

Hi! I believe you should write a measure for your percent of grand total with an ALL function

Something like

Measure = calculate(divide(sum(total claims), calculate(sum(total claims), all(claim_type))

Then use modeling to format as a percentage. Make sure to read the DAX documentation on ALL and VALUES as I think it would be helpful. I would post the links, but am on mobile rn. Hope that is helpful.