Forum Discussion
Custom "Totals" row for matrix
I have a Matrix that shows the most current 13 weeks of data for six different departments, with varying categories for each.
The image I'm attaching is one of the departments with each column representing one of the categories specific to this department and also the total for each week.
The end users are wanting to see the % change between the most current week with the previous week.
I'm able to create a whole new matrix with just that calculation and place it at the bottom of the existing matrix, as shown below:
The problem with doing it this way is that some of the departments have up to 20 categories and the columns of the two visualizations do not stay consistently spaced and it gets ugly.
Is there any way I could get the original matrix to include the calculation in what would normally be utilized as a row for totals, had I chosen that option? I'd like it to be able to update the total row with the rest of the matrix to keep everything aligned, such as in the altered image I created below:
Thanks, in advance, for any assistance you can provide!
yes, that's what HASONEVALUE is for. Remember that a measure is calculated four times in a matrix visual - cell, row total, column total, and grand total.
Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
Do not include sensitive information or anything not related to the issue or question.
If you are unsure how to upload data please refer to https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216
Please show the expected outcome based on the sample data you provided.
Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523
1 Reply
- lbendlin
Super User
yes, that's what HASONEVALUE is for. Remember that a measure is calculated four times in a matrix visual - cell, row total, column total, and grand total.
Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
Do not include sensitive information or anything not related to the issue or question.
If you are unsure how to upload data please refer to https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216
Please show the expected outcome based on the sample data you provided.
Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523