Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
GAURAV7781
Helper III
Helper III

Show total at cell level in matrix

Dear Experinced one 

 

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

 

a.PNG 

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...

1 ACCEPTED SOLUTION
V-pazhen-msft
Community Support
Community Support

@GAURAV7781 

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

 

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

 

V-pazhen-msft_0-1609987046382.png

V-pazhen-msft_1-1609987066743.png


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

View solution in original post

7 REPLIES 7
V-pazhen-msft
Community Support
Community Support

@GAURAV7781 

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

 

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

 

V-pazhen-msft_0-1609987046382.png

V-pazhen-msft_1-1609987066743.png


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
Helper III
Helper III

@amitchandak  Can you please help me in this

CNENFRNL
Community Champion
Community Champion

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

 

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

 


Thanks to the great efforts by MS engineers to simplify syntax of DAX! Most beginners are SUCCESSFULLY MISLED to think that they could easily master DAX; but it turns out that the intricacy of the most frequently used RANKX() is still way beyond their comprehension!

DAX is simple, but NOT EASY!

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

GAURAV7781_0-1609852970494.png

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

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

Thanks to the great efforts by MS engineers to simplify syntax of DAX! Most beginners are SUCCESSFULLY MISLED to think that they could easily master DAX; but it turns out that the intricacy of the most frequently used RANKX() is still way beyond their comprehension!

DAX is simple, but NOT EASY!

@GAURAV7781 , Try an check this measure

I think this should work

 

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

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

GAURAV7781_0-1609856239277.png

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.