Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
I need to create a dynamic table based on the input of a what if parameter. A very simple example is:
Column 1 Column 2
A 1
A 2
B 1
B 2
I want a table created/updated to be only A 1, B 1 if I select 1 and A2, B2 if I select 2 in the what if filter. Not filtering the table, the table itself must only contain the correct rows for relationship purposes.
Is that possible?
Thanks!!!
Solved! Go to Solution.
Hey,
unfortunately this is not possible, due the fact that "virtual" tables - meaning not coming from Power Query, but created using a DAX table statements and used in the model pane - are part of the model, these tables exist "before" a user starts interacting with the model by using slicers and visuals.
Regards
Tom
Hey,
unfortunately this is not possible, due the fact that "virtual" tables - meaning not coming from Power Query, but created using a DAX table statements and used in the model pane - are part of the model, these tables exist "before" a user starts interacting with the model by using slicers and visuals.
Regards
Tom
That is unfortunate, indeed.
Thanks for the quick response!
By the way, you could help accept solution. That way, other community members may also benefit. Your contribution is highly appreciated.
User | Count |
---|---|
128 | |
108 | |
99 | |
65 | |
62 |
User | Count |
---|---|
136 | |
113 | |
102 | |
71 | |
60 |