Forum Discussion

Surashaw's avatar
Surashaw
Frequent Visitor
4 years ago

Crossfiltering doesn't work

Hello, We are trying to navigate from Comp Org Table to OneforceUser's Table we are having issues with the direction of the relationship between the tables (below is the screenshot of the Data mo...
Need Help
johnt75's avatar
johnt75
Super User
4 years ago

Create a Country dimension table like

Country Table = DISTINCT( UNION(
ALLNOBLANKROW('Comp Org'[Country]),
ALLNOBLANKROW('OneForce User'[Country])
))

then link that new table to both 'OneForce User' and 'Comp Org', and use the country column from the new table in all visuals