Measure from different table is displaying the same number for all rows

[Chris2016]

Hello,

Could you please help with this issue?

I have two tables, related with Many to one cardinality and Single cross filtering.

Users

Name

John

Mark

Lily

Jenny

June

Marie

Frank

Assignments

NameID1ActiveCountry

John	123	True	USA
John	456	False	Canada
June	123	True	France
Jenny	123	True	Canada
Jenny	456	False	USA
Marie	123	True	France
Frank	789	True	USA

I have the following measures calculated:
Users Table:

Total Users = DISTINCTCOUNT(Users[Name])

Assignments Table:

Total Assigned = CALCULATE(DISTINCTCOUNT(Assignments[Name]),FILTER('Assignments',Assignments[Active]=FALSE()))

% Users Assigned = [Total Assigned]/[Total Users]

 

If I am plotting all these measures in a matrix, the 'Total Users' measure displays the same number for every row.

 

I cannot change the Cross filter direction to Both because then the '% Users Assigned' is off.

Is there a way to do these calculations in a way that I can display everything in a matrix correctly?

Power Bi Sample file here:
https://www.transfernow.net/dl/20221110x32dkDiR

Thanks!

[Greg_Deckler · Accepted solution]

@Chris2016 You can use CROSSFILTER function to change relationship direction within a measure calculation.

[Chris2016]

Hi, Greg,

Thanks a lot, this worked.

Best regards,

Cristina