cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
B_Adams Member
Member

ISFILTERED for related tables

Hello all

 

I have a Report with a main page, and few additional pages. The main page contains a slicer that is synced and hidden on the other pages. This slicer is the customer name.

 

I want to be every visual empty if no customername is selected on the first page. This worked for everything with the following measure:

HideIfNotFiltered = CALCULATE(IF(ISFILTERED('ssbi Customers'[Name]) || ISFILTERED('ssbi Customers'[ID]);1;0);ALLSELECTED('ssbi Customers'))

I put this measure in the visual level filter of the visuals.

 

But i have one matrix, containing also 2 columns from another table, when i put the measure into the filter there, it just loads (loading circle).

1.PNG

When i upload it and watch it in power BI Service it returns an error:

2.PNG

 

I think this is because the measure only returns the customers table, any suggestions?

4 REPLIES 4
copykai Regular Visitor
Regular Visitor

Re: ISFILTERED for related tables

Hi B_Adams,

 

Does it work correctly if you choose a customer on the main page then?

 

Does the customer table have an active and valid relationship to the tables that uses the BestNettoShare and Pipeline?

B_Adams Member
Member

Re: ISFILTERED for related tables

Hi @copykai 

 

Yes, when i select a customer on the main page it works just fine. All values are correct.

The relationship should be fine as well, otherwise the values wouldnt be correct, right?

copykai Regular Visitor
Regular Visitor

Re: ISFILTERED for related tables

Hi @B_Adams 

 

Yes, that is true.

Perhaps the table/matrix visual is not happy about the HideIfNotFiltered measure.

 

Maybe you can try a similar approach with a distinct count?

HideIfNotFiltered2 = CALCULATE(IF(DISTINCTCOUNT('ssbi Customers'[ID]);1;0);ALLSELECTED('ssbi Customers'))

 

B_Adams Member
Member

Re: ISFILTERED for related tables

Hi @copykai 

 

Thanks for the tipp.

 

Unfortunately it returns in the same result. 

But i figuered out that if i delete the year column it works. So there are to many data. Just cant understand the connection, because it should be empty so no way the matrix shows to much data..

Helpful resources

Announcements
Can You Solve These Challenge

Challenge: Can You Solve These?

Find out how to participate in the first Power BI 'Can You Solve These?' challenge.

Community News & Announcements

Community News & Announcements

Get your latest community news and announcements.

Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Community Kudopalooza

Win Power BI Swag with Community Kudopalooza!

Each week, complete activities and be qualified in the drawing for cool Power BI Swag.

Users Online
Currently online: 45 members 916 guests
Please welcome our newest community members: