topic Values not distributing in matrix in Desktop

Values not distributing in matrix

ecodata512 — Fri, 02 Aug 2024 13:57:29 GMT

Hi guys, I'm currently making a matrix with some measures, and for some reason that values aren't distributing to the rows for the third column (ncr), it's only showing the total. Can I get some help? For context, I tried a calculated column and it showed all the correct values in table view, but it's not showing here in the matrix.

Re: Values not distributing in matrix

Ritaf1983 — Fri, 02 Aug 2024 14:07:45 GMT

Hi ecodata512
If the values are not being sliced according to the matrix categories, it indicates there might be an issue with the relationships, either related to the model or some measure calculated with ALL. To provide more assistance, I would need to see your file, not just through a screenshot.

Can you please share a pbix or some dummy data that keep the raw data structure with expected results? It should help us clarify your scenario and test to coding formula.

How to Get Your Question Answered Quickly

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly

Re: Values not distributing in matrix

Anonymous — Fri, 30 Aug 2024 07:39:49 GMT

Hi ecodata512

Did Ritaf1983 's method solve your problem? If yes, could you please mark it as a solution? This will be of great help to other users experiencing similar problems. Thank you!

If you still have questions, please feel free to contact me.

Best Regards,
Yulia Xu