Need Help with Displaying Correct Subtotals in Power BI Matrix Visual

vs24 — Mon, 29 Apr 2024 06:29:57 GMT

Hello Fabric Community,I need some help with a problem I'm facing in Power BI. I'm using a matrix visual and I want to show individual values from a column (0-1) without summing them up. I used this DAX formula to create a measure:

dax

VAR SelectedValue = SELECTEDVALUE('T&S Table_2'[(0-1)])

RETURN IF(ISBLANK(SelectedValue), 0, SelectedValue)

This measure works well for displaying the data, but the subtotals are not adding up correctly; they just show as 0. I need the subtotals to correctly sum up the values at each level of the hierarchy.

Sample Input Data
Below is a sample of the data from 'Table_2':

-Category A
Subcategory A1	100
Subcategory A2	200
-Category B
Subcategory B1	200
Subcategory B2	300
Subcategory B3	200

Matrix Visual Configuration
- Rows: categroies and subcategories
- Values: The measure based on the (0-1) column

Current Output with Issue
The matrix correctly displays the individual (0-1) values for each ID, but the subtotal is incorrectly showing as 0.

Matrix Visual:

-Category A
Subcategory A1	100
Subcategory A2	200
subtotal	0

-Category B
Subcategory B1	200
Subcategory B2	300
Subcategory B3	200
subtotal	0

Desired Output
I need the subtotal to accurately sum the individual (0-1) values:

-Category A
Subcategory A1	100
Subcategory A2	200
subtotal	300
-Category B
Subcategory B1	200
Subcategory B2	300
Subcategory B3	200
subtotal	700
subtotal (category Aand B comes under one section)	1000

Does anyone have experience with this issue or any advice on how to fix the subtotal calculation in the matrix? Any suggestions would be really helpful.Thanks in advance for your help!

Best regards,

vs24

Re: Need Help with Displaying Correct Subtotals in Power BI Matrix Visual

lbendlin — Mon, 29 Apr 2024 14:32:43 GMT

Looks like your source data may not be in the right format. Try this instead

Then the matrix visual creates itself.

Or if you want the totals at the bottom

topic Need Help with Displaying Correct Subtotals in Power BI Matrix Visual in DAX Commands and Tips

Need Help with Displaying Correct Subtotals in Power BI Matrix Visual

Re: Need Help with Displaying Correct Subtotals in Power BI Matrix Visual