Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Good afternoon,
I am trying to get drillthrough to work from a TopN and Remaining view (show the top 5 customers and group the rest under "Remaining"). The grouping and reporting is working fine thanks to these posts.
https://www.oraylis.de/blog/show-top-n-and-rest-in-power-bi
https://www.minceddata.info/2018/06/06/topsomething-and-all-the-rest-called-other/
But I cannot get the drillthrough to work. This is because the table that is created to hold the list of things + other is not connected to any of the fact tables. I don't think there is a way to get drillthrough to work with the disconnected table but I wanted to ask.
The linked model has a sales table and the topn table as well as topn customer used in the visuals. It also has a drillthrough page set up for testing.
Sample PBIX file: https://www.dropbox.com/s/iaycve8l1ea9vxl/TopN%20and%20Drillthrough.pbix?dl=0
When I drillthrough on a customer with 3.3 M in sales I get the entire 15.3 M on the drillthrough:
Anyone have any thoughts?
Thank you,
John
Solved! Go to Solution.
Hi @jdbuchanan71 ,
Since you have disconnected table when you make the drilltrough it's not filtering any value since they don't have a relationship.
Do the following:
Sales Measure = CALCULATE ( SUM ( Sales[Sales] ); USERELATIONSHIP ( ctCustomers[Customer Description]; Customers[Customer Description] ) )
Result is below and attach PBIX file .
Regards,
MFelix
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsHi @jdbuchanan71 ,
Since you have disconnected table when you make the drilltrough it's not filtering any value since they don't have a relationship.
Do the following:
Sales Measure = CALCULATE ( SUM ( Sales[Sales] ); USERELATIONSHIP ( ctCustomers[Customer Description]; Customers[Customer Description] ) )
Result is below and attach PBIX file .
Regards,
MFelix
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsThank you @MFelix for the answer and including both the .pbix and video! It seems there are two kinds of things in DAX. Those that can be done and those that you just don't know how to do yet.
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsUser | Count |
---|---|
125 | |
106 | |
99 | |
63 | |
62 |
User | Count |
---|---|
135 | |
116 | |
101 | |
71 | |
61 |