Forum Discussion
Resolver IICREATE A TABLE DEPENDING ON A IF
HI,
i have multiple user and depends on the role i want to show some columns or others (a dynamic table depend on a if )
example
table 1
column a, column b, column c, clumn d, column e.
roles
1
2
new calculate table
if( roles = 1 then (create table with columns 'table1' column a, column d, column e ) else if(roles = 2 then (create table with columns table1 column a, column b, column c) else blank
Regards
Hi santiagomur
Please kindly check whether you'd like to get below results:
1. I created a Table with column A&B&C&D&E, and another table with only one column as slicer:
2. Then use below measures to generate the output
field1 = SWITCH([Selected],"1",Max('Table'[B]),"2",Max('Table'[D]))field2 = SWITCH([Selected],"1",Max('Table'[C]),"2",Max('Table'[E]))
2 Replies
- v-diye-msft
Community Support
Hi santiagomur
Please kindly check whether you'd like to get below results:
1. I created a Table with column A&B&C&D&E, and another table with only one column as slicer:
2. Then use below measures to generate the output
field1 = SWITCH([Selected],"1",Max('Table'[B]),"2",Max('Table'[D]))field2 = SWITCH([Selected],"1",Max('Table'[C]),"2",Max('Table'[E])) - sturlaws
Resident Rockstar
Hi santiagomur ,
assuming you want to display this table of yours in the report canvas, you can't change the columns based on user id. You can try to use measures to show different values for each role, but you will not be able to change column names.Or have different pages in your report, for each of your roles.
Cheers,
Sturla
