Measure seems to ignore relationship

[Anonymous]

Hi Guys,

I could not find anything like this via the search, if I missed something please exuse it.

I am not sure if I understand relationships correctly regarding measures. So I have a little demo data model which contains some Users / Names and a dimension table with Cities they live in:

e.g. 

FK stands for Foreign Key and contains the IDs for the cities.

So if I display each name with its respective City it works just fine:

But what I cannot understand is that, if I add a text measure, e.g. 

The table visual seems to ignore that relationship entirely:

Why is that? I tested it in my original report with some measures using SUM, etc, which works. But for Unicode chars or text it seems to fail.

Am I missing something here? I also tried to wrap it into a CALCULATE for the context transition, but that didn't work either.

I'd be glad if someone could shed a little light here for me.

Thank you, Sven

[CNENFRNL · Accepted solution]

@Anonymous , I think it's all about some profound mechanism in data model, namely auto-exist and filter propagation. You might want to google those keywords by yourself.

As to your issue here, a solution is

Circle = IF ( NOT ISEMPTY ( PEOPLE ), UNICHAR ( 11044 ) )

[Anonymous]

Thank you very much. If I understand it correctly auto-exist causes a cross-join here because we filter two different tables and the measure does not result into BLANK() for the non-existing combinations. But I am not sure where filter propagation comes into play.

And your solution uses the fact that we consider the expanded table for people there, am I right?

[amitchandak]

@Anonymous , Try like

maxx(people, unichar(11044)) //people table