Forum Discussion
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
- Anonymous3 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-msftCommunity 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.
- AnonymousNot 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
- AnonymousNot 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
- AnonymousNot 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