Forum Discussion
Summarize Table
Hi guys, I have a trouble here. There are two tables And other table Both have the colummns CodUser in comun I´m doing a new table with [colaboradores] (Distict value)...
Hi, Anonymous
You can try to new a table then rank, Like this:
New Table = SUMMARIZECOLUMNS ( Colaboradores[Colaborador], "Difference", CALCULATE ( COUNTROWS ( PontoB[Diferenca] ), [Diferenca] = "Debito" ) )Did I answer your question ? Please mark my reply as solution. Thank you very much.
If not, please feel free to ask me.Best Regards,
Community Support Team _ Janey
I want a new table showing all "Colaboradores", and a columm with sum of "Diferenca" including the "Colaboradores" withouf diference.
Because after i need rank and show a table like this
v-janeyg-msft
Community Support
Community SupportHi, Anonymous
You can try to new a table then rank, Like this:
New Table =
SUMMARIZECOLUMNS (
Colaboradores[Colaborador],
"Difference", CALCULATE ( COUNTROWS ( PontoB[Diferenca] ), [Diferenca] = "Debito" )
)
Did I answer your question ? Please mark my reply as solution. Thank you very much.
If not, please feel free to ask me.
Best Regards,
Community Support Team _ Janey