Data Model and Matrix Visualization

[PBInonpro]

I have a simple data model. Two tables (1 to Many).

on the lookup table I use a numerical ($) column as the 3rd row, when drill down opens it ... it's shows the total for that category and not the value. So every row in that category shows the total.

is there an obvious step I am missing?

[v-luwang-msft]

Hi @PBInonpro ,

Has your problem been solved, if so, please consider Accept a correct reply as the solution or share your own solution to help others find it.

Best Regards
Lucien

[JekAdq]

Have you checked if your 2 tables have relationship?

or check if the visualization has summed up your values correctly

[Greg_Deckler]

@PBInonpro Can't quite picture what is going on. A screen shot might help. Sample data as text always helps as well.