Forum Discussion
DennisSchlein
Helper III
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 -...
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.
v-jianboli-msft
Community Support
Community SupportHi 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 🙂