Dax Total issu

[somsb]

Hi, I have face issue relating to totals. 

I have created table visuals 
order wise revenue details for category and total revenue.

my category totals are matching but over all revenue total are not matching. please give the correct dax fountion

and I am using dax function total revenue :  calculate(sum of sales),All (category)

thanks in advance

[Greg_Deckler]

@somsb First, please vote for this idea: https://ideas.powerbi.com/ideas/idea/?ideaid=082203f1-594f-4ba7-ac87-bb91096c742e

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

Also: https://youtu.be/uXRriTN0cfY
And: https://youtu.be/n4TYhF2ARe8

[tamerj1]

Hi @somsb 
Please try

total revenue =
SUMX (
    VALUES ( 'Table'[Order Number] ),
    CALCULATE ( SUM ( 'Table'[Sales] ), ALL ( 'Table'[Category] ) )
)