Dynamic numerator based on slicer selections

[Ben_Kronk]

I have a requirement for a Power BI dashboard and I'm not sure how to approach it, or if it's possible.

I need a calculation where the numerator is dynamic based on the slicer selection, but the denominator is static for each selection. The output should be a bar chart with the bars representing the percentages for each line item/category based on the slicer selection.

For example, let's say I need the percentage of Accounts Receivable in the Midwest and South Regions relative to the whole
company, so the selection of the Midwest plus the South (which is the numerator) divided by all Regions' Accounts Receivable (denominator) gives me X%.

In other case, maybe I want the percentage of just the Midwest Region for Accounts Receivable, so the bar chart would update to show the percentage of just the Midwest Accounts Receivable (numerator) divided by all Regions Accounts Receivable (denominator).

I have 30 line items that this would need to work for and each line should update based on the Region selection, whether choosing one region or more than one.

The basic question is: Can I use the selection from a slicer to make a measure with a dynamic numerator but a static
denominator based on a unique line item/category? And if it's not possible to do this specifically, is there another potential solution?

[DataInsights · Accepted solution]

Hi@Ben_Kronk,

You can use the pattern below for the denominator. The ALL function removes the region filter, resulting in the total of all regions. The numerator is simply SUM ( [Amount] ).

All Regions A/R =
CALCULATE ( SUM ( [Amount] ), ALL ( Regions ) )

[Ben_Kronk]

Thank you!