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