Forum Discussion

jhauw74's avatar
jhauw74
Icon for Helper I rankHelper I
1 year ago

Displaying raw data using inactive relationship

Hi Experts,   Would like to get some help if there's a way I can use a calendar based slicers that using inactive relationships? Here's the scenario: Active connection is using created da...
Need Help
jhauw74's avatar
jhauw74
Icon for Helper I rankHelper I
1 year ago

Thanks danextian - yes I have been using that DAX function which working perfectly on measures, however when it comes to visualisation ie. using table to display raw data this is where I think that DAX function not working because the date filter need to use active relationships if that make sense.

danextian's avatar
danextian
Icon for Super User rankSuper User
1 year ago

Inactive relationships will not change the displayed rows.  You can either use a measure that uses USERELATIONSHIP as a visual filter, keep it in the visual and just make the text invisible or use another dimension table that has an active relationship to the other column.