Forum Discussion

zenmemo's avatar
zenmemo
Icon for Helper I rankHelper I
8 years ago
Solved

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 relat...
Need Help
  • ChandeepChhabra's avatar
    ChandeepChhabra
    8 years ago

    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