DAX measure not summarizing correctly

[OlgaJoana]

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!

[OlgaJoana]

The issue is now solved.

Thank your for your time and help Tamer

Have a nice day!

[OlgaJoana]

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!

[tamerj1]

@OlgaJoana 

Please share a meeting link

[OlgaJoana]

Pls try the following:

https://teams.microsoft.com/l/meetup-join/19:meeting_MWI5ZmNmZmMtZDQxZC00YjY4LWJkOTAtMDhlMjU1NTliZjF...

[tamerj1]

Hi @OlgaJoana 

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

[OlgaJoana]

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!

[tamerj1 · Accepted solution]

Hi @OlgaJoana 

Please try

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