Forum Discussion
Resolver IIMeasure not showing value in the matrix visualization
Hi alexa_0028 ，
Try to create a measure like below:
Categorytest = IF ( MAX ( Dimension2[Productcode] ) = MAX ( Dimesion1[Product code] ), MAX ( Dimesion1[Category] ), "Others" )Then create visual:
Did I answer your question? Mark my post as a solution!
Best RegardsLucien
Super Useralexa_0028 you should get the sales for the products E and F, the only thing will be that category column will be blank as seen below
✨ 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.⚡
Resolver IIHi, I do get the values but in total, the value doesn't show in the cell.
I think my problem is similar to this problem, but that is unanswered too.
https://community.powerbi.com/t5/Desktop/Measure-not-showing-value-in-the-table-visualization-but-showing/m-p/851120
- alexa_0028
I tried creating a sample file from my example above and I do get result indeed.But in my main model it doesn't work.I check relationship and it is all same. I am not sure what i am missing. I can't share the original model because it is too big to share and so much data to hide.
My problem is similar to link posted above. Not sure if someone has faced it before.
Result from my model:
I want the sales to show in the cell above rather than just in the grand total.