Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Create a table from slicer

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 , tabl...
General Comment
  • Anonymous's avatar
    Anonymous
    3 years ago

    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's avatar
v-jialluo-msft
Community Support
3 years ago

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's avatar
Anonymous
Not applicable
3 years ago

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