cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper I
Helper I

Selecting values from Userelationship returns blank results

Hi Community,

 

I'm currently working with direct query and my current setup involves two tables. One active relationship between the Dates table and the Identified Dates and another inactive relationship between Dates and Closed Dates. My problem is with the latter...

 

Relationships.JPG

 

When I select values for the active relationship (Count by Identified Date) it returns the corresponding data set.

 

Counts and filter.JPG

 

For the inactive relationship, I was able to get the userelationship function working correctly in that it returns the correct values in my matrix table. My formula:

 

Count by Closed Date = CALCULATE([Count by Identified Date],
'Issues'[Status]="Closed",
USERELATIONSHIP('Issues'[Closed Date Clean],Dates[value]))

 

However, when I go and click on the values in my matrix table for the Count by Closed Date, it doesn't return the values in my corresponding table. I'm definitely missing something here and need help.

 

Thank you very much in advance.

 

Will

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Solution Specialist
Solution Specialist

Re: Selecting values from Userelationship returns blank results

@zenmemo I think the cross filtering happens basis on the active relationship. That could be the reason why your table is blank when you click on [Count by Closed Date]

 

Here is a quick workaround. Add a dummy measure

 

Dummy = IF(OR([Count by Closed Date]<>BLANK(),[Count by Identified Date]<>BLANK()),1,BLANK())

 

Then add this into your table as a last column, it should now work. Here is the snapshot

 

Capture.PNG

 

You can download the powerbi file here

 

Hope it helps

View solution in original post

11 REPLIES 11
Highlighted
Solution Specialist
Solution Specialist

Re: Selecting values from Userelationship returns blank results

@zenmemo, Can you share your pbi file?

Highlighted
Helper I
Helper I

Re: Selecting values from Userelationship returns blank results

Highlighted
Helper I
Helper I

Re: Selecting values from Userelationship returns blank results

Highlighted
Helper I
Helper I

Re: Selecting values from Userelationship returns blank results

Highlighted
Solution Specialist
Solution Specialist

Re: Selecting values from Userelationship returns blank results

@zenmemo Sorry not able to download the file, the link retuns an error

Highlighted
Helper I
Helper I

Re: Selecting values from Userelationship returns blank results

Highlighted
Solution Specialist
Solution Specialist

Re: Selecting values from Userelationship returns blank results

Still gives an error, can you share the file via drop box or google drive

Highlighted
Helper I
Helper I

Re: Selecting values from Userelationship returns blank results

Highlighted
Solution Specialist
Solution Specialist

Re: Selecting values from Userelationship returns blank results

@zenmemo I think the cross filtering happens basis on the active relationship. That could be the reason why your table is blank when you click on [Count by Closed Date]

 

Here is a quick workaround. Add a dummy measure

 

Dummy = IF(OR([Count by Closed Date]<>BLANK(),[Count by Identified Date]<>BLANK()),1,BLANK())

 

Then add this into your table as a last column, it should now work. Here is the snapshot

 

Capture.PNG

 

You can download the powerbi file here

 

Hope it helps

View solution in original post

Helpful resources

Announcements
Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

Mark your calendars and join us for our next Power BI Dev Camp!.

Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Tech Marathon

Maratón de Soluciones de Negocio Microsoft

Una semana de contenido con +100 sesiones educativas, consultorios, +10 workshops Premium, Hackaton, EXPO, Networking Hall y mucho más!

Top Solution Authors
Top Kudoed Authors