visual total not matching sum of individual row

[sapirmarko]

hi,

I use with this DAX measure to get a value on matrix :

STILLS_JUICE =

var POINT= CALCULATE(MAX(SKU_Racing[ point]),SKU_Racing[tag_name]="stiils" && SKU_Racing[product_group]="JUICE")

var COUNT1 =CALCULATE(MAX(SKU_Racing[count]),SKU_Racing[tag_name]="stiils" && SKU_Racing[product_group]="JUICE")

var x=

IF(CALCULATE(DISTINCTCOUNT(Sale_Out[product_master_id]),Product_Tags[STILLS]="JUICE")>=COUNT1, POINT,BLANK())

var y = SUMMARIZE(Sale_Out,Sale_Out[creator_id],Sale_Out[outlet_id], "xx",x)

return IF(

HASONEVALUE(Sale_Out[creator_id]) && HASONEVALUE(Sale_Out[outlet_id]),x,

SUMX(y,[xx]))

I get the correct number of each line but not in total.
I did the same measure to another  Product_Tags[STILLS] ="JUICE" and I get the correct number of each line but not in total.

for the both of them I get 75 in total ( because the number of line that I get is 25 ant it's sum all the lines even if it's blank)
and I still get a mistake on the total table :

thank you for your help!

[sapirmarko]

it's doesn't work.. maybe because I have 2 categories?

[mahoneypat · Accepted solution]

Please see this video for how to get your expected total with a reference to your existing measure.

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

Pat

[sapirmarko]

I use SUMX but still I didn't get the right result

[Anonymous]

Hi @sapirmarko,

It seems like a common multiple aggregation calculation issues, you can take a look at the following blog if helps:

Measure Totals, The Final Word 

Regards,

Xiaoxin Sheng