Create a table from slicer

[Anonymous]

Hi ,

I have one table (tabla 1) with 10 columns and I meed to select values from a column (in a slicer) an create a new table (tabla 2) with the same columns in order to do an EXCLUDE(tabla 1 , tabla2) and obtain a tabla 3 with the values excluded between them.

Can you help me ? 

Thanks

[Anonymous]

Hi I create a new table creating a FILTER(tabla, any filter) in order to create an updated table from the original and then create a FLAG in the new one.

Thanks

[Anonymous · Accepted solution]

Hi @v-jialluo-msft 
Thanks for your replay ,
Just a correction, only I need to build the new table PrivilegedAccounts2 (in your case) came from the Table PrivilegedAccounts (table 1) in order to re calculate other measures,.

Thanks

[v-jialluo-msft]

^{Hi @Anonymous ,}

^{Please follow these steps:}

^{(1) Create a new measure}

FLAG =
IF (
    ISFILTERED ( 'PrivilegedAccounts'[DomainAndSam] ),
    IF (
        MAX( 'PrivilegedAccounts2'[DomainAndSam] )
            IN VALUES ( PrivilegedAccounts[DomainAndSam] ),
        1,0
    )
)

^{(2) Filter numeric values}

^{(3)Final output}

^{Best Regards,}

^{Gallen Luo}

^{If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.}

[Anonymous]

Hi ,

I have 1 table (Table1) with 10 columns and I need to create a new table (Table2) (phiscally) exactly the same columns as Table1 but except the rows selected from slicer from a column from Table1 .

This is because I need to create a Table3 (phisically) from both tables with the DAX function EXCEPT(Table1,Table2) .

Can you help me ? 

Thanks 

Carlos