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

      • Anonymous's avatar
        Anonymous
        Not applicable
        3 years ago

        Hi Mike

        This is an example of measure that I need to re calculate with the new rows (in a new table or not)

         

        FILTER(INCIDENTNUMBER) =
        VAR PERIODOMINIMO = CALCULATE(MAX(CALENDARIO[Date]), DATEADD((CALENDARIO[Date]),-2,MONTH))
        VAR PERIODOMAXIMO = CALCULATE(MAX(CALENDARIO[Date]))
        RETURN
        CALCULATE(SELECTEDVALUE(DatosWebCenter[Incident Number]),  KEEPFILTERS(DatosWebCenter[Fecha_ID] >= PERIODOMINIMO && DatosWebCenter[Fecha_ID] < PERIODOMAXIMO), ALL(CALENDARIO))
         
        As you can see there is a name of the actual table (DatosWebCenter) in the CALCULATE funct. so in order to re calculate this measure I need a new table to recalculate this o is not necesary ? 
        The same situation with graphics 
        Many thanks