Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
BCGR
Frequent Visitor

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

1 ACCEPTED SOLUTION
BCGR
Frequent Visitor

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

View solution in original post

3 REPLIES 3
BCGR
Frequent Visitor

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

BCGR
Frequent Visitor

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

lbendlin
Super User
Super User

The advice to duplicate the column doesn't work, 

The advice is to duplicate the table, not the column.

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.