Forum Discussion

Nino_Birdie's avatar
Nino_Birdie
Frequent Visitor
6 years ago

Remove duplicates and blanks

Im trying to make a calculated table and i cant remove the duplicates, leaving blanks between data. The query is the following:   DatosExtra = DISTINCT(SELECTCOLUMNS(EstadosPostulantes; ...
Need Help
Nino_Birdie's avatar
Nino_Birdie
Frequent Visitor
6 years ago

amitchandakI tried both of your codes and they throw me the following

A single value for column 'Etapa' in table 'EstadosPostulantes' cannot be determined. This can happen when a measure formula refers to a column that contains many values without specifying an aggregation such as min, max, count, or sum to get a single result.

 

And if i apply minx or maxx inside EstadosPostulantes[Etapa] it only returns me one row.

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
6 years ago

I took this from you if, what is the condition you want to put here. Yes , either they can column from same table or a column from the filter table and value like the other filter

EstadosPostulantes[Etapa] = [Etapa]
  • Nino_Birdie's avatar
    Nino_Birdie
    Frequent Visitor
    6 years ago

    amitchandak  meanwhile i have created a mockup of what i expected, and also new columns Called NExito and NFracaso, the following query :

    DatosExtra = 
   UNION(
       ROW("Etapa";1;"Exito"; 1;"Fracaso";"";"NExito";"a";"NFracaso";"");
        ROW("Etapa";2;"Exito";3;"Fracaso";2;"NExito";"c";"NFracaso";"b");
        ROW("Etapa";3;"Exito";5;"Fracaso";4;"NExito";"e";"NFracaso";"d");
        ROW("Etapa";4;"Exito";7;"Fracaso";6;"NExito";"f";"NFracaso";"g");
        ROW("Etapa";5;"Exito";9;"Fracaso";8;"NExito";"i";"NFracaso";"h");
        ROW("Etapa";6;"Exito";11;"Fracaso";10;"NExito";"k";"NFracaso";"j");
        ROW("Etapa";7;"Exito";13;"Fracaso";12;"NExito";"m";"NFracaso";"l")
       )

     

    Returns the following (what i expected):

     

     

    So, is there something i can do to replicate that? By making rows or columns?

    • Nino_Birdie's avatar
      Nino_Birdie
      Frequent Visitor
      6 years ago

      Up. I still cant figure how to do what i need 😐