topic DAX Measure not subtotaling in DAX Commands and Tips

DAX Measure not subtotaling

noahbowerman — Fri, 28 Oct 2022 20:30:25 GMT

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]))

Re: DAX Measure not subtotaling

ppm1 — Sat, 29 Oct 2022 00:35:39 GMT

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

Re: DAX Measure not subtotaling

daXtreme — Sun, 30 Oct 2022 07:57:17 GMT

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.

Re: DAX Measure not subtotaling

noahbowerman — Mon, 31 Oct 2022 18:44:58 GMT

Thanks!

Re: DAX Measure not subtotaling

Anonymous — Tue, 01 Nov 2022 08:50:52 GMT

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