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!

     

Uzi2019's avatar
Uzi2019
Icon for Community Champion rankCommunity Champion
2 years ago

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

 

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

 

Hi Uzi2019 


This is the data in excel. Thank you.

CodeCategoryBudgetCommitted amount
ITBDUpgrade234134
ITHQRegulation174942
ITHQMaintenance174953
  • Uzi2019's avatar
    Uzi2019
    Icon for Community Champion rankCommunity Champion
    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!