Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

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

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 slicer

 

 

  • Mikelytics's avatar
    Mikelytics
    Icon for Resident Rockstar rankResident Rockstar
    3 years ago

    Hi 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

    • Anonymous's avatar
      Anonymous
      Not applicable
      3 years ago

      Hi Mike ,

      let me explain in the simple way.

      I have a table Table1 

      INCNombre del clienteOrganizationImpactUrgencyPriorityAssigned Group
      INC000004888277Sabrina GinerCUSTOMER SERVICE3-Moderado/Limitado2-AltaAltaCONTROL DE RED
      INC000004888318Sabrina GinerCUSTOMER SERVICE3-Moderado/Limitado2-AltaAltaAUTOMATIZACION
      INC000005156499Erika BravoCUSTOMER SERVICE3-Moderado/Limitado1-CríticaAltaAUTOMATIZACION
      INC000004866388Ana Laura MedinaCUSTOMER SERVICE3-Moderado/Limitado1-CríticaAltaAUTOMATIZACION
      INC000005158616VANESA ROXANA SANCHEZCUSTOMER SERVICE3-Moderado/Limitado1-CríticaAltaCONTROL DE RED
      INC000004902569Romina Soledad Meza AguirreCUSTOMER SERVICE3-Moderado/Limitado2-AltaAltaCONTROL DE RED
      INC000004864264Sabrina GinerCUSTOMER SERVICE3-Moderado/Limitado2-AltaAltaGCA OPE
      INC000004886538Romina Soledad Meza AguirreCUSTOMER SERVICE3-Moderado/Limitado2-AltaAltaGCA OPE
      INC000005047570VANESA ROXANA SANCHEZCUSTOMER SERVICE3-Moderado/Limitado1-CríticaAltaGCA OPE
      INC000004885831Sabrina GinerCUSTOMER SERVICE3-Moderado/Limitado2-AltaAltaGCA OPE
      INC000004996172VANESA ROXANA SANCHEZCUSTOMER SERVICE3-Moderado/Limitado1-CríticaAltaCONTROL DE RED
      INC000004925960Ana Laura MedinaCUSTOMER SERVICE3-Moderado/Limitado1-CríticaAltaCONTROL DE RED
      INC000005047642VANESA ROXANA SANCHEZCUSTOMER SERVICE3-Moderado/Limitado1-CríticaAltaCONTROL DE RED
      INC000004983994Exequiel Maximiliano GarciaCUSTOMER SERVICE3-Moderado/Limitado1-CríticaAltaCONTROL DE RED
      INC000004921458Gabriel Alberto SilvaCUSTOMER SERVICE3-Moderado/Limitado1-CríticaAltaCONTROL 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 

       

       

       

       

       

      • Mikelytics's avatar
        Mikelytics
        Icon for Resident Rockstar rankResident Rockstar
        3 years ago

        Hi Anonymous 

         

        I totally get what you explain. But why the heck to you nieed a thrid physical table. WHy not filtering it logically and doing calculations on top? as I said, physical table won't work. SO what calculation do you want to do on table 3?

         

        Best regards

        Michael