Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello,
So I have a table_1 from which I'm building a measure to calculate cost.
I have another table_2 to which I want this cost measure to flow into.
Both of these tables are related to the calendar_table, but unrelated to each other. How can I achieve this ?
I need the cost measure to be responsive to all the lookup table filters from table_2 that are connected to it.
Thanks for your help
Solved! Go to Solution.
@miketondu , You have to create additional common dimension, to make it responsive
or use treatas to pass values
https://www.sqlbi.com/articles/propagate-filters-using-treatas-in-dax/
@miketondu , You have to create additional common dimension, to make it responsive
or use treatas to pass values
https://www.sqlbi.com/articles/propagate-filters-using-treatas-in-dax/
User | Count |
---|---|
98 | |
91 | |
82 | |
73 | |
67 |
User | Count |
---|---|
115 | |
102 | |
98 | |
71 | |
66 |