Grand total not matching in table/matrix

[alexa_0028]

Hi All,

I have measure like below :

IS PY-2 = CALCULATE([Sales],filter('C Account','C Account'[C. Account Code (CAC)]IN VALUES (parents[code]) ),filter('Product','Product'[P. Code]IN VALUES(products_los[Product Code])),'Calendar'[py_min2_flag]=1,'M Sales'[flag_sample]=0)

I am trying to rewrite my DASX but my grandtotal is not matching.

Proposed_IS PY-2 =

var is_py_min_2 = CALCULATE([Sales ],filter('C Account',' C Account'[C. Account Code (CAC)]IN VALUES (parents[code]) ),filter('Product','Product'[P. Code]IN VALUES(products_los[Product Code])),'Calendar'[py_min2_flag]=1,'M Sales'[flag_sample]=0)

RETURN

IF ( HASONEFILTER('parents'[Group]), is_py_min_2,SUMX(VALUES(parents[Group]),is_py_min_2))

Model :

[alexa_0028 · Accepted solution]

Hi All, 
I got the results by first creating a measure and then creating second measure to apply grand total.
I also made the relationship as bidirectional for product_los table.
SUMX(KEEPFILTERS()) was the key thing to use as I want my table to keep the filters from the other column.

Proposed_IS PY-2 =

var is_py_min_2 = CALCULATE([Sales ],filter('C Account',' C Account'[C. Account Code (CAC)]IN VALUES (parents[code]) ),filter('Product','Product'[P. Code]IN VALUES(products_los[Product Code])),'Calendar'[py_min2_flag]=1,'M Sales'[flag_sample]=0)

grand_total_fix=

IF ( HASONEFILTER('parents'[Group]), [Proposed_IS PY-2],SUMX(KEEPFILTERS(VALUES(product_los[LOS])),[Proposed_IS PY-2]))

[v-henryk-mstf]

Hi @alexa_0028 ,

Please provide the relevant information and test data according to the following blog content, and I will answer you as soon as possible.

How to Get Your Question Answered Quickly - Microsoft Power BI Community

Looking forward to your reply.

Best Regards,
Henry

[alexa_0028]

Hi @vanessafvg 
thanks for sharing the link
I updated my DASX and still i am getting incorrect result

Proposed_IS PY-2 =

var is_py_min_2 = CALCULATE([Sales],filter('C Account','C Account'[C. Account Code (CAC)] IN VALUES (parents[code]) ),filter('Product','Product'[P. Code]IN VALUES(products_los[Product Code])),'Calendar'[py_min2_flag]=1,'M Sales'[flag_sample]=0)

RETURN

SUMX(

SUMMARIZE('parents',[Group], "test",is_py_min_2),[test])

[vanessafvg]

its really  hard to read what you are doing, if you are able to suppy data in text format that would be better.

also when you say it is wrong which is correct?  you need to provide more information if you need help

providing sample data 

explaining which total you expecting

explain what you trying to do from a business requirement perspective

explaning where the error is

[vanessafvg]

you need to understand how power bi works, this video explains why totals dont always match. In your second calc you are using an iterator so that is probably why

https://www.youtube.com/watch?v=Rii_6qkLNh8