Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I'm attempting to drillthrough my TopN customer table, the drillthrough is working for the Top N, but is it possible to also have the 'Remaining' drillthrough?
I've created an inactive relationship between Customer table and ctCustomers by the column description
and utilizing this measure to use on the drillthrough table;
Sales Measure = CALCULATE ( SUM ( Sales[Sales] ); USERELATIONSHIP ( ctCustomers[Customer Description]; Customers[Customer Description] ) ) |
https://drive.google.com/file/d/1rvwOEmeXnPpXAI9GAE4i1lUkV8cRcYVF/view?usp=sharing
Solved! Go to Solution.
Hi @TariqArnabi ,
According to your description, I download your sample, as the Sales Measure results in a blank value on the Remaining row, so the Remaining row doesn't show.
In the Drill Through page, turn on the Show items with no data option, it works fine.
Best Regards,
Community Support Team _ kalyj
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @TariqArnabi ,
According to your description, I download your sample, as the Sales Measure results in a blank value on the Remaining row, so the Remaining row doesn't show.
In the Drill Through page, turn on the Show items with no data option, it works fine.
Best Regards,
Community Support Team _ kalyj
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
104 | |
101 | |
79 | |
72 | |
64 |
User | Count |
---|---|
142 | |
108 | |
101 | |
81 | |
74 |