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 , tabla2) and obtain a tabla 3 with the values excluded between them.

 

Can you help me ? 

Thanks

  • 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

     

4 Replies

  • v-jialluo-msft's avatar
    v-jialluo-msft
    Community Support

    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

      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

  • Anonymous's avatar
    Anonymous
    Not applicable

    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

     

  • Anonymous's avatar
    Anonymous
    Not applicable

    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