Forum Discussion

pankajj's avatar
pankajj
Helper III
6 years ago
Solved

Measure Error in MATRIX - Power BI

I have 2 tables: ACCOUNT BUDGET this has many AC ID and Description and the budget for each year and respective month. Other table is SALES DATA Which has Shipped Amount, Remaining Amount (calcul...
Need Help
  • pankajj's avatar
    pankajj
    6 years ago

    Thank you for the guidance. I was able to fix my problem by creating additional measures and a Summarize Table.

Greg_Deckler's avatar
Greg_Deckler
Community Champion
6 years ago

I don't understand what is wrong. Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

 

Maybe a measures total problem? Very common. See my post about it here: https://community.powerbi.com/t5/DAX-Commands-and-Tips/Dealing-with-Measure-Totals/td-p/63376

Also, this Quick Measure, Measure Totals, The Final Word should get you what you need:
https://community.powerbi.com/t5/Quick-Measures-Gallery/Measure-Totals-The-Final-Word/m-p/547907

pankajj's avatar
pankajj
Helper III
6 years ago

Thanks a ton Greg for your quick help.

 

I tried your solutions however i am still unable to match Excel results in Power Bi Metrix visual.

 

edhans 

v-yuta-msft 

 

Thank you very much for your response to my query.

 

Apologies for not providing the data file. The actual data is too large and complicated, the way it is created by my colleague in Excel.

 

I will create a sample file and upload it for your kind review and possible solution support.

 

Thank you very much once again. You are an excellent support to the Community.

 

Best regards,

 

PG