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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
HLST
Frequent Visitor

Matrix Column Totals alternatives

Is it possible to change the row "Total" which sums up each column, to variance, median, mean, etc.

I'm trying to visualise budgeted sales to actual sales and instead of seeing the sumation of these I would ideally like to see the variation to budget or even the average.

Is this possible? 

 

HLST_1-1632890616709.png

@Reuben @amitchandak  

 

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

@HLST 

The "total" doesn't really mean sum up the values, it is just a label that display of the aggregation of visual value. For example, if I want it to be AVERAGE, I can create an measure =  average([value]), and change the label from "Total" to "Average" under the "subtotals" section in the format panel. This also applies to variance, mean, median, etc. You need to create an appropriate measure and change the label accordingly. 

 

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

4 REPLIES 4
V-pazhen-msft
Community Support
Community Support

@HLST 

Vpazhenmsft_0-1633591544900.png

Here is my example table.

 

 

Paul Zheng _ Community Support Team

Best Regards

 

 

V-pazhen-msft
Community Support
Community Support

@HLST 

The "total" doesn't really mean sum up the values, it is just a label that display of the aggregation of visual value. For example, if I want it to be AVERAGE, I can create an measure =  average([value]), and change the label from "Total" to "Average" under the "subtotals" section in the format panel. This also applies to variance, mean, median, etc. You need to create an appropriate measure and change the label accordingly. 

 

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

Are you able to share what your fields look like in this case?

I am still a little unclear on how to change the Column totaal values to variance or average without using code.

amitchandak
Super User
Super User

@HLST ,isinscope can help

I think you need use column on column of matrix

 

If(isinscope(Table[COlumn]), [Budget], [Variance])

 

https://www.kasperonbi.com/use-isinscope-to-get-the-right-hierarchy-level-in-dax/

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.