Forum Discussion

pang22's avatar
pang22
Icon for Helper III rankHelper III
2 years ago
Solved

Correct the total in Matrix

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 budg...
Need Help
  • Uzi2019's avatar
    Uzi2019
    2 years ago

    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_'s avatar
Wilson_
Icon for Memorable Member rankMemorable Member
2 years ago

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?