Newbie question - filter related data

[DennisSchlein]

Hi 

i'm brand new with PBI. I'm trying to create one of my first very basic models.
And thus this is probably a simple question, I don't yet know how to solve it.

On my main table - I have a consignee number - a customer number.
This customer number have a relationship to cg2 (group of customers within this brance)
and cg2 has a relationship to cg1. Which is the top level.

Within cg1 I have a list of customers beeing invoiced from a certain solution. that list of cg1 id's is in the table: InvoiceCustomers.

But I want to show name from cg1, that has a relation to InvoiceCustomers.

How do I do that?

Thanks in advance, 

[v-jianboli-msft · Accepted solution]

Hi @DennisSchlein ,

Based on your description, I have created a simple sample:

Then apply the measure:

_Name = CALCULATE(MAX('cg1'[Name]),FILTER(ALL(cg1),[Code]=MAX('InvoiceCustomers'[CustomerGrouping])))

Final output:

Best Regards,

Jianbo Li

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[DennisSchlein]

Hi @v-jianboli-msft this gives mes exactly what I was looking for 🙂 thank you very much 🙂 

[DennisSchlein]

if I in dax studio do this:
NATURALLEFTOUTERJOIN ( InvoiceCustomers, cg1 )

I get :

How do I write the same in PBI?