Line graph with correct value with slicer

[Anonymous]

Hi I have a table like this:

Name	Date	Type	Miles	Hours	Miles Per Hour
AAA	11/1/2021	Actual	89	5	17.80
AAA	11/2/2021	Actual	110	4	27.50
AAA	11/3/2021	Actual	85	4	21.25
BBB	11/1/2021	Actual	122	4	30.50
BBB	11/2/2021	Actual	81	4	20.25
BBB	11/3/2021	Actual	97	7	13.86
CCC	11/1/2021	Actual	113	5	22.60
CCC	11/2/2021	Actual	98	7	14.00
CCC	11/3/2021	Actual	126	7	18.00

Miles Per Hour is Calculated by Miles/ Hour

I'm creating a trend line, with Date on the X axis and Miles Per Hour on the Y axis with Name on the slicer

You see that the problem comes when I unclick all the slicer, I want the "Miles Per Hour" to be the total "Miles" across all "Names" divided by the total "Hours" across all "Names" within each "Date"

But here, it is adding up all the "Miles Per Hour" for each "Name" in that "Date".

Does anyone know how to solve this?

[Anonymous]

Hi I'm sorry, du you know how to share the file?

Cause I cna't find where

[v-easonf-msft]

Hi, @Anonymous 

You can upload you sample file to cloud storage and then share the link.

Best Regards,
Community Support Team _ Eason

[Anonymous]

https://dpdhl-my.sharepoint.com/:u:/r/personal/emily_tsai_dhl_com/Documents/powerBI/Example.pbit?csf... 

[Anonymous]

let me know wether this works

[v-easonf-msft]

Hi, @Anonymous 

I don't have permission to access the file.

Can you check the type of  the Shareable link?

Best Regards,
Community Support Team _ Eason

[v-easonf-msft]

Hi, @Anonymous 

How did you create the trend line, add auxiliary lines in the ‘Analyze panel’ or create an additional measure?

Please share your sample file on the cloud for further research.

Best Regards,
Community Support Team _ Eason