Summarize Table

[Anonymous]

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) and count of columm [diferenca] with values no blank.

A new table like
[colaboradores] [diferenca]
Pablo                   15
Joao                     8

Follow the relantiohip 

Thank´s 

[bcdobbs]

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.

[parry2k]

@Anonymous where you are doing distinct count? Why do you want to create a new table? You can simply write a measure and visualize it?

✨ Follow us on LinkedIn

Learn about conditional formatting at Microsoft Reactor

My latest blog post The Power of Using Calculation Groups with Inactive Relationships (Part 1) (perytus.com) I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

⚡ Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡

[Anonymous]

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 · Accepted solution]

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