Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
ThomasWeppler
Continued Contributor
Continued Contributor

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 drilldown. , while one the other option they all stay when I drilldown. Does anyone know why that is?

 

See the picture for an example.

 

123.png

1 ACCEPTED SOLUTION
ThomasWeppler
Continued Contributor
Continued Contributor

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.

View solution in original post

5 REPLIES 5
ThomasWeppler
Continued Contributor
Continued Contributor

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
Continued Contributor
Continued Contributor

Sure 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

 

 

 

345.png

 

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.

124.png

ThomasWeppler
Continued Contributor
Continued Contributor

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.

 

ThomasWeppler_0-1608284750689.png

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.

 

321.png

@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... 


Please @mention me in your reply if you want a response.

Copying DAX from this post? Click here for a hack to quickly replace it with your own table names

Has this post solved your problem? Please Accept as Solution so that others can find it quickly and to let the community know your problem has been solved.
If you found this post helpful, please give Kudos C

I work as a Microsoft trainer and consultant, specialising in Power BI and Power Query.
www.excelwithallison.com

AllisonKennedy
Super User
Super User

@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??


Please @mention me in your reply if you want a response.

Copying DAX from this post? Click here for a hack to quickly replace it with your own table names

Has this post solved your problem? Please Accept as Solution so that others can find it quickly and to let the community know your problem has been solved.
If you found this post helpful, please give Kudos C

I work as a Microsoft trainer and consultant, specialising in Power BI and Power Query.
www.excelwithallison.com

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.