Forum Discussion
ThomasWeppler
Impactful Individual
Impactful IndividualMatrix 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...
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.
ThomasWepplerImpactful Individual
Impactful IndividualSure I can share the DAX code but again I don't think it will help you much.
The matrix has 3 values made as measures in DAX they are here and 3 rows which I have identified in the model
The 3 circles indicate which colums I use and the color of the underscore indicate how the model is connected.
The dax and the models connections are the same for both models which is why I am so confused about the different visualisation.