Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Matrix Total incorrect when collapsed

Hi All,   i have a table that looks like this: Location Material Order Order $ Stock Inv$ Work Orders WorkOrder $ Total new York Apples -1           -1 new York Apples -...
Need Help
Anonymous's avatar
Anonymous
Not applicable
4 years ago

i have tried both, i'm goign to try and sub out my dataset so i can post the pbix file with "Dummy data" since the actual data is confidential

 

v-janeyg-msft's avatar
v-janeyg-msft
Community Support
4 years ago

Hi, Anonymous 

 

If you're using measure in matrix, It's normal to have problems, because the context of the matrix is complex, it will change after folding, and the value of measure itself will change with the context. You need to formulate a specific measure for the matrix visual.

So can you share some sample data (not a matrix) and your desired result(in visual)? Then we can help you soon.

 

Best Regards,
Community Support Team _ Janey