Forum Discussion
New table from slicer
HI,
I have one table T1 (with 10 columns an one colum is call INC ) .
I create a slicer with this column INC .
I need to create a new table T2 with the sames columns like T1 but without the chosen rows in the slicer. This T2 Table should be phisical in order to create new formulas and do EXCEPT function with DAX.
Thanks
9 Replies
Hi Anonymous
Unfortunately this should not be possible because the physical tables of the Power BI data model are created and updated during the report refresh and not by interacting on the report/vizualisation layer (like with slicers).
Best regards
Michael
-----------------------------------------------------
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly. Appreciate your thumbs up!
@ me in replies or I'll lose your thread.
-----------------------------------------------------
Anonymous
Can you please elaborate why you need a new physical table for additional calculations? WHy can it not be a logical table in a measure where you put calculations on top?
Best regards
Michael
Hi
The main idea to do this is because I have a Dash with graphic and formulas from a Tabla 1 and the idea is to EXCLUED one o many values from de graphics (column INC in Tabla 1) and then I need to automatically recalculate all the formulas and graphics again withourt this excluded values from slicerHi Anonymous
Lets try whether we can find another way. But to do that I would need some sample data, a picture of the data model (relevant tables only) incl. columns and relations and the expected result.
Best regards
Michael
Hi Mike ,
let me explain in the simple way.
I have a table Table1
INC Nombre del cliente Organization Impact Urgency Priority Assigned Group INC000004888277 Sabrina Giner CUSTOMER SERVICE 3-Moderado/Limitado 2-Alta Alta CONTROL DE RED INC000004888318 Sabrina Giner CUSTOMER SERVICE 3-Moderado/Limitado 2-Alta Alta AUTOMATIZACION INC000005156499 Erika Bravo CUSTOMER SERVICE 3-Moderado/Limitado 1-Crítica Alta AUTOMATIZACION INC000004866388 Ana Laura Medina CUSTOMER SERVICE 3-Moderado/Limitado 1-Crítica Alta AUTOMATIZACION INC000005158616 VANESA ROXANA SANCHEZ CUSTOMER SERVICE 3-Moderado/Limitado 1-Crítica Alta CONTROL DE RED INC000004902569 Romina Soledad Meza Aguirre CUSTOMER SERVICE 3-Moderado/Limitado 2-Alta Alta CONTROL DE RED INC000004864264 Sabrina Giner CUSTOMER SERVICE 3-Moderado/Limitado 2-Alta Alta GCA OPE INC000004886538 Romina Soledad Meza Aguirre CUSTOMER SERVICE 3-Moderado/Limitado 2-Alta Alta GCA OPE INC000005047570 VANESA ROXANA SANCHEZ CUSTOMER SERVICE 3-Moderado/Limitado 1-Crítica Alta GCA OPE INC000004885831 Sabrina Giner CUSTOMER SERVICE 3-Moderado/Limitado 2-Alta Alta GCA OPE INC000004996172 VANESA ROXANA SANCHEZ CUSTOMER SERVICE 3-Moderado/Limitado 1-Crítica Alta CONTROL DE RED INC000004925960 Ana Laura Medina CUSTOMER SERVICE 3-Moderado/Limitado 1-Crítica Alta CONTROL DE RED INC000005047642 VANESA ROXANA SANCHEZ CUSTOMER SERVICE 3-Moderado/Limitado 1-Crítica Alta CONTROL DE RED INC000004983994 Exequiel Maximiliano Garcia CUSTOMER SERVICE 3-Moderado/Limitado 1-Crítica Alta CONTROL DE RED INC000004921458 Gabriel Alberto Silva CUSTOMER SERVICE 3-Moderado/Limitado 1-Crítica Alta CONTROL DE RED I need to create a slicer with the INC column from Table 1
Then If I select from the slicer any INC from the Table 1 (not only one) I need to create a new Table (Table2 ) with only the 2 INC selected
Now the Idea is to have a Table 3 without these 2 INC values, this step should be in DAX (EXCEPT funtion) due to I need to re calculate all formulas and grafics witohit the values selected in the slicer.
All tables are not related
