CREATE A TABLE DEPENDING ON A IF

[santiagomur]

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

[v-diye-msft · Accepted solution]

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]

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