topic Re: Wrong Total in Developer

Wrong Total

sraj — Mon, 01 Jun 2020 12:29:04 GMT

Good morning,

I am trying to get the Net pay on my bi report but it shows 64500.01 as my total netpay instead of 8826.7, I am not sure why this may be happening...please help. Thank you!

Re: Wrong Total

Greg_Deckler — Mon, 01 Jun 2020 12:53:08 GMT

@sraj This looks like a measure totals 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

Re: Wrong Total

sraj — Mon, 01 Jun 2020 13:12:25 GMT

Hi Greg,

I dont have any if's like 1000 above then total...I want a straight total. How would I do that using your suggestion.?

Thanks for your help!

Re: Wrong Total

Greg_Deckler — Mon, 01 Jun 2020 15:09:29 GMT

@sraj - Not quite clear on what you are saying.

Also, 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

The most important parts are:
1. Sample data as text, use the table tool in the editing bar
2. Expected output from sample data
3. Explanation in words of how to get from 1. to 2.

Re: Wrong Total

sraj — Mon, 01 Jun 2020 16:31:44 GMT

I am trying to get the Net pay on my bi report but it shows 64500.01 as my total netpay instead of 8826.7, I am not sure why this may be happening...I had mentioned all the examples above so didnt know it wasnt viewable. In your example it has an if statement >1000...I am looking for every value out there.

Thank you!