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

!! Power BI 101 Interview questions !! !! Master Microsoft Fabric- 36 Videos !!
Microsoft Power BI Learning Resources, 2023 !!
Learn Power BI - Full Course with Dec-2022, with Window, Index, Offset, 100+ Topics !!
Did I answer your question? Mark my post as a solution! Appreciate your Kudos !! Proud to be a Super User! !!

Filter

Helpful resources

Power BI Monthly Update - September 2024

Microsoft Fabric & AI Learning Hackathon

Fabric Community Update - September 2024

How to Get Your Question Answered Quickly