Forum Discussion
Creating a User Selection table
Hi,
I want to make a user selection table as follows:-
When I create this I only get one Column Selected table I need to Select multiple columns in single table,I done this using following
Measure Selection =
SWITCH(TRUE(),
VALUES('Column'[Column]) = "Total Sales", [Total Sales] ,
VALUES('Column'[Column]) = "Total Cost", [Total Cost],
VALUES('Column'[Column])= "Total Profit", [Total Profits],
BLANK())
How to make this from DAX,since switch can only choose one selection and tables get only one value per column.
Please Help !!!!
Thank You
Best Regards,
Dora
5 Replies
HI Dora,
Can you please explain more about your requirement?
AFAIK, one measure is impossible to return multiple values at same time.(switch function also not works for summary records)
If you mean display dynamic multiple columns based on slicer and switch function, it is impossible to achieve.
Regards,
Xiaoxin Sheng
Hi @Xiaoxin Sheng
I need to make a table which columns can be selected by user .User can select multiple columns according to requirment.
Then How can I make a table which columns can be chosen according to customer selection.
Thank You,
Best Regards,
Dora
HI Dora,
Current you can't use filter or slicer to create dynamic column/table:
Calculated Column/Table Change Dynamically According to Slicer Selection in the Report.
Regards,
Xiaoxin Sheng
