Crossfilter and Left Join in DAX

[PatPeerate]

Hello,

My source is a SSAS Tabular database. I have this kind of data model. Relationship between Country and Organization is a one-to-many.

I'm trying to obtain a result like this :

KPI_IN_FACT_2	ORGANIZATION	COUNTRY
4	org1	country1
5	org2	country1
78	org3	country2
54	(null)	country3

Currently, i cant see the last line, where a country doesn't have an organization. In KPI_IN_FACT_2 formula i need a CROSSFILTER (ORGANIZATION, COUNTRY, both) (for other calculations) and i think that CROSSFILTER do an INNER JOIN between these two tables. I need to "override" this INNER with a LEFT in order to obtain all these 4 lines in my results.

Thanks a lot

Patrice

[Greg_Deckler]

@PatPeerate - I am not understanding this, see attached PBIX. Page 3, Tables 5, 6 and 7

[PatPeerate]

Thanks for your answer. It's not exactly my case. I have a country with no entry in organization table.

You can find an example here

Thanks a lot.