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
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