Forum Discussion
Filter tables without relationships
Hi, I'd like to create a "dynamic" table which should be filtered by other tables, but without using relationships (I have too many of them in place already). The reason for this is that I need this...
mahoneypat
Microsoft Employee
Microsoft EmployeeCalculated tables like that one are static, but you likely want to use TREATAS in a measure instead, as follows:
New Measure = CALCULATE([YourMeasure], TREATAS(VALUES(Source[ID]), Destination[ID]))
Use that pattern for each of the measures that work on the Destination table that you need. You would need to use slicers, etc. from your Source table if you need to select certain values.
If this works for you, please mark it as the solution. Kudos are appreciated too. Please let me know if not.
Regards,
Pat