Forum Discussion

ThomasWeppler's avatar
ThomasWeppler
Icon for Impactful Individual rankImpactful Individual
5 years ago
Solved

Matrix drilldown removes subtotals

I have two similar matrixes in two diffrent reports. They should show the same, but when I use the drilldown option on one of them all the subtotals disappears unless they are relevant for the drilld...
Need Help
  • ThomasWeppler's avatar
    ThomasWeppler
    5 years ago

    So I manage to rebuild the grey and red model from scrach useing the exact same dax and model and now it works like the blue version. Basically a turn it on and off again situation.

     

    So in short the problem is gone, but the mystery has not been solved.

AllisonKennedy's avatar
AllisonKennedy
Icon for Community Champion rankCommunity Champion
5 years ago

ThomasWeppler  These look like very different data values, what is in the 'values' for each of these matrices? And what do they look like when you haven't expanded the values? I suspect it will have to do with the measure that's used in the values, and some context change it has asked for??