Forum Discussion
Resolver IFilter values in one table column based on values in a different table column.
314mp_M0th4 , You can have measure like
calculate(sum(Table1[Values]), filter(Table1, Table1[Project] in values(Table2[Values]) ))
or use Treatas
https://docs.microsoft.com/en-us/dax/treatas-function
or Create common dimensions
Power BI- DAX: When I asked you to create common tables: https://youtu.be/a2CrqCA9geM
https://medium.com/@amitchandak/power-bi-when-i-asked-you-to-create-common-tables-a-quick-dax-solution-8e3eccb41bda
Super User314mp_M0th4 , You can have measure like
calculate(sum(Table1[Values]), filter(Table1, Table1[Project] in values(Table2[Values]) ))
or use Treatas
https://docs.microsoft.com/en-us/dax/treatas-function
or Create common dimensions
Power BI- DAX: When I asked you to create common tables: https://youtu.be/a2CrqCA9geM
https://medium.com/@amitchandak/power-bi-when-i-asked-you-to-create-common-tables-a-quick-dax-solution-8e3eccb41bda