Forum Discussion
Subtotal not correct in matrix
- 4 years ago
a119526 try this measure
SUMX( SUMMARIZE ( 'SAP Sales Daily', 'SAP Sales Daily'[ABRV_DESC], 'Product'[gpn]), VAR volLY = [Volume LY Test] VAR volCY = [Volume CY] VAR salesLY = [Sales LY test] VAR salesCY = [Sales CY] VAR priceCY = [Price CY] VAR priceLY = [Price LY Test] RETURN IF ( ( volLY * volCY * salesLY * salesCY ) + 0 <> 0, volLY * ( priceCY - priceLY ) ) )✨ Follow us on LinkedIn
Check my latest blog post The Power of Using Calculation Groups with Inactive Relationships (Part 1) (perytus.com) I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!
⚡ Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡
a119526 very hard to figure out from image, drop a sample pbix file to look into it.
Sorry about that parry2k .
I tried dropping the file at the link below. Not sure if there is a better way to share .pbix files? I couldn't upload to the community forum directly. Thank you for your help.
The visualization I am trying to fix is on the PVM Product Tab.
https://drive.google.com/file/d/1b2RFHHSrPq2WZGr_NpN3VxznEUT_ngvy/view?usp=sharing