topic Re: DAX measure not summarizing correctly in DAX Commands and Tips

DAX measure not summarizing correctly

OlgaJoana — Mon, 12 Jun 2023 13:15:35 GMT

Hi all,

I created a measure which works fine on row level but not on total level.

This is my measure:

VAR _NUM = CALCULATE( [CP_RR_All Products], FILTER('Dim_Customer', 'Dim_Customer'[SalesNetworkCustomer_Name] = "Account Pure Player" || 'Dim_Customer'[SalesNetworkCustomer_Name] = "Account Specialized" ), FILTER('Dim_Product', 'Dim_Product'[Item type descr] = "FINISHED GOODS"), FILTER('Dim_Customer', 'Dim_Customer'[InternationalGroupName] <> "1.AMAZON"), FILTER('Dim_Product', 'CP_RR - Product List'[CP_List Products RR] = 1))

As you can see, the total at the end of 122201.89 is not correct.

Who can help?

Thank you!

Re: DAX measure not summarizing correctly

tamerj1 — Mon, 12 Jun 2023 13:19:18 GMT

Hi OlgaJoana

What column(s) do you have in the same table visual?

Re: DAX measure not summarizing correctly

OlgaJoana — Mon, 12 Jun 2023 14:21:13 GMT

Hi,

The table is the following:

And I need to divide the "M2" by the "CP_RR_All Products" (the percentage result of this math is in the column "CP_Evaluation_RecoRange%" - for example, 3020.25 / 9010.42 = 34%). And this works by line, but not in the total level (as you can see 3020.25 + 750719.90 = 753740.15 and 753740.15 / 95792031.32 = 0.78% and not 19%)

Thnak you!

Re: DAX measure not summarizing correctly

tamerj1 — Mon, 12 Jun 2023 15:06:36 GMT

Hi OlgaJoana

Please try

M2 CorrectTotal = SUMX ( CROSSJOIN ( VALUES ( 'Date'[Year] ), VALUES ( 'Table'[SalesNetworkCustomer_Name] ) ), [M2] )

Re: DAX measure not summarizing correctly

OlgaJoana — Mon, 12 Jun 2023 17:07:56 GMT

Hi,

Thank you for the tip, but it's not working...

Is there any possibility to have a call with you, so that I can easily explain what I need?

Thanks!

Re: DAX measure not summarizing correctly

tamerj1 — Mon, 12 Jun 2023 17:22:43 GMT

OlgaJoana

Please share a meeting link

Re: DAX measure not summarizing correctly

OlgaJoana — Mon, 12 Jun 2023 17:28:25 GMT

Pls try the following:

https://teams.microsoft.com/l/meetup-join/19:meeting_MWI5ZmNmZmMtZDQxZC00YjY4LWJkOTAtMDhlMjU1NTliZjFl@thread.v2/0?context=%7B%22Tid%22:%22be702899-adb0-4f70-a46a-8c9219608ab8%22,%22Oid%22:%22f98b6c63-8add-4831-a2be-2328c1f70743%22%7D

Re: DAX measure not summarizing correctly

OlgaJoana — Mon, 12 Jun 2023 18:00:20 GMT

The issue is now solved.

Thank your for your time and help Tamer

Have a nice day!