Forum Discussion
Solved
Sum based on Distinct values on another Column
I am trying to ratio based on sum(unique values on a column)/ Count(Values on Column) Warehouse Processing %:= DIVIDE ( CALCULATE ( SUM ( [Warehouse Processing Offset] ), 'Orders'[DC Ready...
The calculations did not work and I ended up creating a calculated table with distinct values to achieve.
hi, sgsukumaran
Could you please tell me if your problem has been solved? If it is, could you please mark the helpful replies as Answered?
Best Regards,
Lin
The calculations did not work and I ended up creating a calculated table with distinct values to achieve.