Correct the total in Matrix

[pang22]

Hello

I have a table with budget and amount
$234 budget fot ITBD
$1749 budget for ITHQ

When I make matrix in PowerBI, the budget column will auto sum, so I choose minimum for budget by each code. But the total row will only show the minimum (234)

How to correct the total to a correct format? (i.e. 234+1749 = 1983)

[Uzi2019]

Hi @pang22 
Can you can share the Sample data in excel or pbix file so will look into this?

[pang22]

Hi @Uzi2019 

This is the data in excel. Thank you.

Code	Category	Budget	Committed amount
ITBD	Upgrade	234	134
ITHQ	Regulation	1749	42
ITHQ	Maintenance	1749	53

[Uzi2019 · Accepted solution]

Hi @pang22 

Please try the below measure for your Budget value.

Measure =

SUMX(DISTINCT('Table'[Code]),CALCULATE(MIN('Table'[Budget])))

I am getting the expected output you wanted.

I hope I answered your question!

[Wilson_]

Hi pang22,

You chose minimum, so your matrix is showing you the minimum. Why does sum not work for you? What output are you looking for?

[pang22]

Hi @Wilson_ 

If choose sum, it will sum the buget

Becasue I only have one budget for each Code. And spend in each category.
$234 budget fot ITBD, spend $134
$1749 budget for ITHQ, spend $42 & $53

I am looking for the table in below format with correct total (i.e. 234+1749 = 1983)