Coloums total is not sum up the actual

[CBP-GM-ATLAS]

Hi Greetings to you all !!!

I am CBP..

  see teh below , is my desttop table.. where the no of orders coloum , the sum is acutually 265(if we sum the each row manualy )  ,, but in table shows only 255 ..... could you please clarify if you are !!

Note : I have used teh measures in calculations .. ref: in below :

[Greg_Deckler]

@CBP-GM-ATLAS 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

[CBP-GM-ATLAS]

Hi thanks for replying !!!

  even after changing the the DAX ,, as per your input .. still tehere is no change on the results 

USED DAX: 

total orders  new DAX =

var __table = SUMMARIZE('PO (2)','PO (2)'[Order No], "__sku",[no of orders])

RETURN

IF(HASONEVALUE('PO (2)'[Order No]),[No of orders],SUMX(__table,[__sku]))

Report Link 

https://app.powerbi.com/links/-9AmjkEB6G?ctid=797d0fd2-36f9-429c-9b1a-d16ecdcb3fd7&pbi_source=linkSh...

fyr.. and move..

Thanks

CBP

[Yossarian]

Hi,

You are using distinct count. There are probably some Order No repeated in different months (so, they sum to a number bigger than 1, but in the total line only count as 1).

Is that it?