Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more

Reply
Surashaw
Frequent Visitor

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 model)
Trying to calculate the trotal days for each employee with the below DAX expression. 
When we try to plot the Country, WWID from a single table we get the correct value of tyhe Total Days for each employe. 
But when we plot the vizual with Country from a different table (Comp Org Table) and the Total Days measure it crossfilters and give me the record for all WWID's present in the model and doesn't restrict it to a specific country.
I tried using the Crossfilter function buit its doens work in this situation.

Total Days AUX =
Calculate(SUMX(VALUES('OneForce User'[OneForce User L1 WWID]),Calculate(If('Calculated Measure'[First Call Date AUX]>= 'Calculated Measure'[Start Date AUX],DATEDIFF([First Call Date AUX],'Calculated Measure'[End Date AUX],DAY),DATEDIFF('Calculated Measure'[Start Date AUX],'Calculated Measure'[End Date AUX],DAY)))))

Total Days =
Calculate(SUMX(VALUES('OneForce User'[OneForce User L1 WWID]),'Calculated Measure'[Total Days AUX]))

Surashaw_0-1655468126425.png


It would be realy helpfull if someone can help us with a solution.

Regards

2 REPLIES 2
Surashaw
Frequent Visitor

Hello johnt75,

Thank you for your response.
Tried the approach but with this I get a constant value for all countries but that should not be the case here.

Regrads,

johnt75
Super User
Super User

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

Helpful resources

Announcements
Power BI DataViz World Championships

Power BI Dataviz World Championships

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!

December 2025 Power BI Update Carousel

Power BI Monthly Update - December 2025

Check out the December 2025 Power BI Holiday Recap!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.