Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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...
When I select values for the active relationship (Count by Identified Date) it returns the corresponding data set.
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
Solved! Go to Solution.
@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
You can download the powerbi file here
Hope it helps
Still gives an error, can you share the file via drop box or google drive
@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
You can download the powerbi file here
Hope it helps
User | Count |
---|---|
93 | |
84 | |
78 | |
75 | |
66 |
User | Count |
---|---|
115 | |
105 | |
93 | |
65 | |
60 |