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

 

I have tried dax measure as Calculate (Sum(Value),AllSelected(Dataset)  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...

[V-pazhen-msft · Accepted solution]

@GAURAV7781 

You should filter the Periods to get your expected result. Try this measure:

Measure = CALCULATE(SUM([Value]),FILTER(ALLSELECTED('Table'),[Period]=MAX([Period])))

Paul Zheng _ Community Support Team
If this post helps, please Accept it as the solution to help the other members find it more quickly.

[GAURAV7781]

@amitchandak  Can you please help me in this

[CNENFRNL]

Hi, @GAURAV7781 , you might want to tweak your measure this way,

CALCULATE ( SUM ( 'Dataset'[Value] ), ALLSELECTED( 'Dataset'[Brand] ) )

[GAURAV7781]

hi @CNENFRNL when user selects Brand it shows 88 instead of 139

[CNENFRNL]

@GAURAV7781 , if you need a sum up regardless of any filter on brand, the measure is

CALCULATE ( SUM ( 'Dataset'[Value] ), ALL( 'Dataset'[Brand] ) )

[amitchandak]

@GAURAV7781 , Try an check this measure

I think this should work

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

[GAURAV7781]

i tried but but when i select brand this does not show column total