Forum Discussion
Solved
Another drill-through question..
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 ...
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