Incorrect Values Displaying on Tooltips

[ahiemstra]

I have a conundrum I’m hoping someone might be able to help me with. I have a report which details employees on the x-axis and time on the y-axis. A sample of the report looks like this:

The bar chart is displayng Encounter Time.

I can’t seem to screenshot the tooltip on the bar however it’s displaying:

Provider: SarahM

Encounter Time: 16.25

Indirect Time: 2.75

Ratio: 86:14

These values are correct and align with the values you see on the cards at the bottom of the report.

The values and chart are accurate when you are displaying only 1 provider. If however I want to see more than 1 provider or all registered dietitians (RDs) and I select accordingly, the Indirect Time value and Ratio that display on the tooltip are no longer accurate. The Encounter Time remains accurate. When more than 1 provider is selected, it’s as though the Indirect Time value is reflecting the sum of Indirect Time for those selected which is subsequently also factoring into the Ratio causing it to be inaccurate.

Essentially, the values displaying on the chart for SarahM (including the values on the tooltip) need to remain as they are stated above, rather than changing as other RDs are brought onto the chart.

Indirect Time, Direct Service, Indirect Service and Ratio are all DAX calculations.

In essence:

Direct Service = Encounter Time / (SUM(Encounter Time)+SUM(Indirect Time))

Indirect Service = Indirect Time / (SUM(Encounter Time)+SUM(Indirect Time))

Ratio = Direct Service : Indirect Service

It might be easiest for me to share my sample .pbix file so this all makes more sense. I’ll attempt to do this however I’ve never tried before so it might fail!

https://ln5.sync.com/dl/06a9c9bc0/qgbmwxq5-dpgawtkq-aj6gcecn-r535stmh

Thanks in advance for your help.

[HotChilli · Accepted solution]

I have had a look at the pbix.  It's got the wrong Employee Name field on the x-axis. These are the fields which are used to slice and dice the data so you want a field from a dimension table.  Remove the 1ON1[Employee full name] and replace with EMPLOYEES[Employee full name]

[ahiemstra]

Silly me, thank-you!