Trouble with measures and tooltips

Hi,

As per your understanding, the goal is to show each payer’s percentage of the total event volume when hovering over the chart, while keeping filters such as event, year/quarter, and other slicers.

The issue occurs because your denominator is filtering to Payer = "Projected Total", which only returns values for that line. As a result, the percentage for other payers becomes blank and the total shows 100%.

Recommended Approach

Instead of filtering to "Projected Total", calculate the total across all payers by removing only the payer filter.

Example:

Volume =
SUM(Pain_event_counts[Count])

Total Volume (All Payers) =
CALCULATE(
[Volume],
REMOVEFILTERS(Pain_event_counts[Payer])
)

% of Total Volume =
DIVIDE(
[Volume],
[Total Volume (All Payers)]
)

This Works

• REMOVEFILTERS(Payer) removes only the payer filter.
  • All other filters (event, year, quarter, etc.) remain applied.
  • Each payer is divided by the same total volume for that point in time.

When hovering a point on the chart you will see something like:

Private → Count + % of total
Medicare FFS → Count + % of total
Medicaid → Count + % of total
Total → 100%

Add the % of Total Volume measure to the Tooltip field well of the visual so viewers can see both counts and percentages.

This approach keeps the calculation dynamic across all slicers and time periods.

Thanks!

If you have a payer dimension (recommended), remove filters from that table/column, not the fact table.

Volume =
SUM ( Pain_event_counts[Count] )

Projected Total Volume =
CALCULATE (
    [Volume],
    REMOVEFILTERS ( 'Payer'[Payer] ),    
    'Payer'[Payer] = "Projected Total"
)

% of Projected Total =
DIVIDE ( [Volume], [Projected Total Volume] )