Forum Discussion
Need help with price effect calculation
Hi, I tried using both calculated column and measure to calculate price impact but it is not returning my desired results. My goal is to create a visualization with a slicer which would show price i...
Hi Anonymous ,
Thank you for your kind reply!
Could you please provide a screenshot of this if it is in excel?
Thanks for your understanding. Your time and cooperation are much valued by us. We are looking forward to hearing from you to assist further.
Best regards,
Lucy Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi! I created this measure and came out with 430 for the total:
Measure = SUMX('Table',('Table'[Price CY]-'Table'[Price PY])*'Table'[Units CY])
What the SUMX does is allow the ('Table'[Price CY]-'Table'[Price PY])*'Table'[Units CY]) to be calculated at each row, then it adds all of those values together.