Solved: Re: Filter

Anonymous · ‎09-03-2019

Is it possibile in dax to apply a filter referring to another table? Like that:

CALCULATE(sum(Colonne[Valori 2018]);filter(righe;Righe[Padre]="Attività dell'ente segnalante"))

v-lili6-msft · ‎09-03-2019

hi, @Anonymous

Yes, you could.

and I think what you need is RELATED or RELATEDTABLE in the calculation. (The relationship between the two tables must already be established )

https://docs.microsoft.com/en-us/dax/related-function-dax

https://docs.microsoft.com/en-us/dax/relatedtable-function-dax

Best Regards,

Lin

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

View solution in original post

v-lili6-msft · ‎09-03-2019

hi, @Anonymous

Yes, you could.

and I think what you need is RELATED or RELATEDTABLE in the calculation. (The relationship between the two tables must already be established )

https://docs.microsoft.com/en-us/dax/related-function-dax

https://docs.microsoft.com/en-us/dax/relatedtable-function-dax

Best Regards,

Lin

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

amitchandak · ‎09-03-2019

Create a new column in your table. This one created in item table using sales tables

 Maxx(filter(sales,Sales[item_id]='Item'[Item ID]),Sales[Order Id])

Full Power BI Video 20 Hours YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

Filter

Helpful resources

Join us at the Microsoft Fabric Community Conference

Power BI Monthly Update - January 2025

Fabric Community Update - January 2025

How to Get Your Question Answered Quickly

New Offer! Become a Certified Fabric Data Engineer