Forum Discussion
Helper IIINewbie question - filter related data
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,
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.
3 Replies
v-jianboli-msftCommunity Support
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.
DennisSchleinHi 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?