DAX matrix subtract

[lukmtb08]

Dear community, 

I would like to have a matrix with group, country and the related values. My problem is that country "C" in group 1 is also part of group 2  splitted about all group 2 values. Therefore, I would like to subtract values for "C" from group 2. 

Do you have any best preactice solutuons for this? 

Thank you very much!

Group	Country
1	A
1	B
1	C
2	D
2	E
2	F

[Anonymous · Accepted solution]

Hi @lukmtb08 ,

I'm a little confused about your needs, Could you please explain them further? It would be good to provide a screenshot of the results you are expecting and desensitized example data.

Thanks for your efforts & time in advance.

Best regards,
Community Support Team_Binbin Yu