Calculated Table

[kdumas]

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!!!

[TomMartens · Accepted 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

[kdumas]

That is unfortunate, indeed.

Thanks for the quick response!

[v-chuncz-msft]

@kdumas,

By the way, you could help accept solution. That way, other community members may also benefit. Your contribution is highly appreciated.