DAX Measure not subtotaling

[noahbowerman]

I've created a custom measure called "Turn Ratio" but it does not work for totals and subtotals. What am I doing wrong? 

PU&SO = [Pickups] + [Deliveries]

Turn Ratio = ( DIVIDE( (DIVIDE([PU&SO], (SELECTEDVALUE(Stop[Total trailers])))), [Count Weeks]))

[v-shex-msft]

Hi @noahbowerman,

Did the above suggestions help with your scenario? if that is the case, you can consider Kudo or Accept the helpful suggestions to help others who faced similar requirements.

If these also don't help, please share more detailed information to help us clarify your scenario to test.

How to Get Your Question Answered Quickly 

Regards,

Xiaoxin Sheng

[daXtreme]

Hi @noahbowerman 

Since you're a new member on the forum, I'd strongly and kindly suggest that you read this first (before posting any questions): How to Get Your Question Answered Quickly - Microsoft Power BI Community

It should help you obtain good answers quickly. Really.

[noahbowerman]

Thanks!

[ppm1 · Accepted solution]

Please see this article and video.

Why Power BI totals might seem inaccurate - SQLBI

(2) Power BI - Tales from the front #01 - Getting the Right Total - YouTube

Pat