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])

Join us as experts from around the world come together to shape the future of data and AI!
At the Microsoft Analytics Community Conference, global leaders and influential voices are stepping up to share their knowledge and help you master the latest in Microsoft Fabric, Copilot, and Purview. ✨
️ November 12th-14th, 2024
 Online Event
Register Here

Filter

Helpful resources

Power BI Monthly Update - October 2024

Fabric Community Update - October 2024

How to Get Your Question Answered Quickly