Show total at cell level in matrix

[GAURAV7781]

Dear Experinced one 

I have requirement wher in i have showcase all columns value at cell level

If I select Brand in slicer then also it should should 121

I have tried dax measure as Calculate (Sum(Value),AllSelected(Dataset),Values(Dataset[Period])  which is giving me grand total in all cells, Please help

below is the attached dataset:

https://onedrive.live.com/embed?resid=3EC4F058F07E9D81%21119&authkey=%21ANzmpqgAazgCtjA&em=2&AllowTy...

[Anonymous · Accepted solution]

Hi @GAURAV7781 

You can try my measure to use all function to achieve your goal.

My measure:

M_Value = SUMX(CALCULATETABLE('Table',ALL('Table'[Brand])),[Value])

Result is as below.

By Default:

Select State in slicer:

You can download the pbix file from this link: Show total at cell level in matrix

 

Best Regards,

Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly. 

[ryan_mayu]

@GAURAV7781 

maybe you can try this

Measure = CALCULATE(SUM('Table'[Value]),REMOVEFILTERS('Table'[Brand]))

please see the attachment below

[amitchandak]

@GAURAV7781 , I think this should work

Calculate (Sum(Dataset[Value]),AllSelected(Dataset)))

[GAURAV7781]

I tried but when i select Brand it dont show column total

[ryan_mayu]

@GAURAV7781 

have you tried my solution. Does it work for you?

[amitchandak]

@GAURAV7781 , You are filtering brand then only one brand is there, then the total will match with that brand.

Please check You have shown filter of Market in the first screen shot

If you want to ignore all filters

Calculate (Sum(Dataset[Value]),All(Dataset)))