topic Dax Total issu in DAX Commands and Tips

Dax Total issu

Anonymous — Wed, 08 Feb 2023 12:07:56 GMT

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

tamerj1 — Wed, 08 Feb 2023 12:15:56 GMT

Hi Anonymous
Please try

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

Greg_Deckler — Wed, 08 Feb 2023 12:40:08 GMT