Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
Hi. I can see through my search thorugh this forum, that I am not the first to ask about restricting drill-though, however, I have found no post that needs exactly what I need.
The situation:
I have a report, where it is possible for the user to click in a Company from a list, and drill-through to a page that shows that company's information, financial numbers etc. That company is also a part of an industry.
What I need:
I need to be able to show, on the same dashboard, the company's financial numbers compared to the industry's average. This is currently not possible for me, because the drill-through filters all data on the company level. The advice to duplicate the column doesn't work, as the data is already filtered on the company level.
There have been some answers to use a DAX formulate to CALCULATE, with the ALL(measure) on the filter, however, that won't do, as I need the measure to be filtered on the company industry.
This seems like such an obvious use-case, and I almost can't believe that PowerBI does not support this?
Solved! Go to Solution.
Received the answer from some colleagues.
The result var to make new measures with all of the financial numbers I need, but with an ALL() filter.
FinancialNumbers =
CALCULATE(SUM([FinancialNumber]),ALL([CompanyName]))
Where the ALL([CompanyName]) negates the drill-through filter. This could be applied to any filters I would like to negate
Received the answer from some colleagues.
The result var to make new measures with all of the financial numbers I need, but with an ALL() filter.
FinancialNumbers =
CALCULATE(SUM([FinancialNumber]),ALL([CompanyName]))
Where the ALL([CompanyName]) negates the drill-through filter. This could be applied to any filters I would like to negate
Yeah alright, that makes sense. However, this does not solve my problem. I need some of the filters carried over, but not all.
In Tableau terms, it would be an LoD expression. I.e. I need to make PowerBI ignore the individual company in the drill through, but keep the rest of the filters, i.e. industry
The advice to duplicate the column doesn't work,
The advice is to duplicate the table, not the column.
User | Count |
---|---|
120 | |
69 | |
68 | |
57 | |
50 |
User | Count |
---|---|
166 | |
82 | |
68 | |
65 | |
54 |