topic Totals are WRONG After getting values from Parameters in DAX Commands and Tips

Totals are WRONG After getting values from Parameters

KS_India — Sat, 23 Mar 2024 06:00:27 GMT

I am one more challenge. Now, total is not right. Here is the snip

Formula I have used for New Incentive is

New Incentive = if(MAX('Table'[Commodity])="Hardware",SELECTEDVALUE(Incentive[Incentive]),MAX( 'Table'[Incentive]))

and for New Sales

New Sales = max('Table'[Net Price])-('Table'[New Incentive])

Can you please look at it one more time.

Many Thanks

Greg_Deckler — Sat, 23 Mar 2024 13:33:49 GMT

Anonymous — Tue, 26 Mar 2024 05:46:51 GMT

Thanks Greg_Deckler for the quick reply and solution. Here are some of my additions:

We can create two new measures.

_New Incentive = SUMX(VALUES('Table'[Commodity]),[New Incentive])

_New Sales = SUMX(VALUES('Table'[Commodity]),[New Sales])

Then the result is as follows.

Best Regards,

Neeko Tang

If this post  helps, then please consider Accept it as the solution  to help the other members find it more quickly.

KS_India — Tue, 26 Mar 2024 06:20:44 GMT

Super Thanks. Much Appreciated.