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.

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

Thanks for the quick answer.
The visual options are different and the names of the columns are different, but the dax and measures are copy pasted.

Both worked like the blue version earlier today so when I expanted the table all the colums showed so that makes me think that the problem is in formating rather than the DAX or measure, but I could be wrong.

Here I have the tables where I have not expanted any options and all rows are showen.

 

Here I have another example where I have expanted the table twice and again the blue table shows all rows while the grey and red table only shows the rows that has been expanted.

 

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

ThomasWeppler  What has changed since this morning? Are you able to share the DAX values formula? Without more info it's hard to troubleshoot or guess what's going on, but we see this behaviour sometimes with ISINSCOPE or other similar functions...