Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

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)...
Need Help
  • v-janeyg-msft's avatar
    v-janeyg-msft
    4 years ago

    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

bcdobbs's avatar
bcdobbs
Community Champion
4 years ago

Try

 

New Table =
    SUMMARIZECOLUMNS(
        Colaboradores[Colaborador],
        "Distinct Count", DISTINCTCOUNT(PontoB[Diferenca])
    )

parry2k  is right though a measure would do the job or you could add a calculated column to Colaboradores.