Forum Discussion

mb0307's avatar
mb0307
Icon for Responsive Resident rankResponsive Resident
4 years ago

Dynamic SUMX

Hi guys,   DAX below just works fine on a single column (Product): RowSum = SUMX( VALUES( dimMaster[Product] ), ABS( [DiffCalculation] ) )   How can I make this dy...
Need Help
parry2k's avatar
parry2k
Icon for Super User rankSuper User
4 years ago

 what is the expression of your following measure?ABS( [DiffCalculation] )

 

mb0307

mb0307's avatar
mb0307
Icon for Responsive Resident rankResponsive Resident
4 years ago

parry2k  that is the difference between Sales - Forecast.  ABS to convert any -ve to +ve.

 

Sales and Forecast are two tables, connected to Master Table by Product Number.

Thanks