Forum Discussion
Create calculated column in Table2 that can be sliced using fields from Table1
Hi jbstephenson,
I'm this case you need to create a measure to make the calculation dinamically try the following.
Measure =
=countrows(FILTER(table1 ,table1[date received] >MAX( table2[arbitrary date]) & & table1[date processed] > MAX( table2[arbitrary date] ))
Super UserHi jbstephenson ,
To create a relationship between tables you need to follow this guidance.
https://learn.microsoft.com/en-us/power-bi/transform-model/desktop-create-and-manage-relationships
But in this case I have some doubts you refer that you want to have a filter on the colour? does this means that you want the calculated table to be dinamic based on selection?
Yes, I need it to be dynamic based on selection
- MFelix
Hi jbstephenson,
I'm this case you need to create a measure to make the calculation dinamically try the following.
Measure =
=countrows(FILTER(table1 ,table1[date received] >MAX( table2[arbitrary date]) & & table1[date processed] > MAX( table2[arbitrary date] ))
Ah, you're right, thanks! I had also tried a measure using CALCULATE with filter arguments instead of just using FILTER.
