Total count not correct

[space83]

Have any idea why total in Open PO amount columns is not properly sum?

This is original function of power bi. i am not use my own function.

When u sum manually u will not got the number in red crop.

[v-cgao-msft]

Hi @space83 ,

May I ask if your problem has been solved? If not, these may be helpful to you.

Power BI: Totals Incorrect and how to Fix it

Learn How to Fix Totals and Subtotals in DAX

It makes it easier to give you a solution.

1. Sample (dummy dataset) 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.

How to provide sample data in the Power BI Forum

How to Get Your Question Answered Quickly

Best Regards,
Community Support Team_Gao

If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly -- How to provide sample data

[space83]

hi @v-cgao-msft 

I dont have opportunity to test all the solution given. thanks for your feedback.

please consider this issue has fix at this moments.

[amitchandak]

@space83 , need share formula

many you need a measure like

new measure = sumx(summarize(Table, Table[Receipt Line], Tbale[Receipt Date], "_1", [Current measure]), [_1])

Also check

https://www.youtube.com/watch?v=ufHOOLdi_jk