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
sevenhills's avatar
sevenhills
Super User
4 years ago

I am not sure how the matrix looks like...

 

One thing I noticed is you are using HASONEFILTER, Try using "HASONEVALUE" and see if that fixes

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