Problemas con GROUPBY

Question

Hola Comunidad,&nbsp;&nbsp;tengo el siguiente problema con un groupBy&nbsp;Codigo:compras = GROUPBY(ih_hist20062020,&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;ih_hist20062020[Fecha factura]. Año],&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;ih_hist20062020[Nombre],&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;"Total",SUMX(CURRENTGROUP(),ih_hist20062020[Monto Neto]),&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;"Cantidad de Invoice",COUNTX(CURRENTGROUP(), COUNTROWS(DISTINCT(ih_hist20062020[Invoice]))))&nbsp;La suma del total, cuadra pero al buscar el numero de Invoice, el cual se repite, me devuelve un numero de 1456 cuando deberia ser 1220&nbsp;alguno idea o estopy haciendo mal la agrupacion???

mahoneypat · Accepted Answer

Have you tried the same with SUMMARIZE instead to simplify it
&nbsp;
Purchases =ADDCOLUMNS&nbsp;(&nbsp;&nbsp;&nbsp;&nbsp;SUMMARIZE&nbsp;(&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;ih_hist20062020,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;ih_hist20062020[Invoice&nbsp;Date].[Year],&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;ih_hist20062020[Number]&nbsp;&nbsp;&nbsp;&nbsp;),&nbsp;&nbsp;&nbsp;&nbsp;"Total",&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;CALCULATE&nbsp;(&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;SUM&nbsp;(&nbsp;ih_hist20062020[Net&nbsp;Amount]&nbsp;)&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;),&nbsp;&nbsp;&nbsp;&nbsp;"Cantidad&nbsp;de&nbsp;Invoice",&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;CALCULATE&nbsp;(&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;DISTINCTCOUNT&nbsp;(&nbsp;ih_hist20062020[Invoice]&nbsp;)&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;))
&nbsp;
Pat

Forum Discussion

Problemas con GROUPBY

2 Replies

Related content

GroupBY and summarize

Problemas con los interruptores

Problema con MAXX

Problemas con tabla calendario

Problema con Groupby