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 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
    • Mikelytics's avatar
      Mikelytics
      Icon for Resident Rockstar rankResident Rockstar
      3 years ago

      HI Anonymous 

       

      I here the first time that you NEED to calculte another physical table before you get the result. In a measure you can calculate Table as a variable and then reuse the variable to do your further calculations.

       

      Instead of speaking about the measure you already build can you please explain the business problem? I see we have a list of incidents. What do you want to calculate and how do you want to visualize it?

       

      Best regards

      Michael

      • Anonymous's avatar
        Anonymous
        Not applicable
        3 years ago

        Hi Mike, sorry for the delay.

        Instead of doing another table I have the solution with the slicer with all Select values .

        When I need to "select" a value in order to exclude it, I deselect one/any values and all Dash will be re calculated.

         

         

         

         

        Now I need to put in better way the slicer in order to create a table with all the selected values.

        Thanks