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
The advice to duplicate the column doesn't work, The advice is to duplicate the table, not the column.