virtual table count values

[Fiala]

Hellou, I need help with counting values in virtual tables.

I have created this:
table1 =
SUMMARIZECOLUMNS(
    'Agent list'[Date],
    'Agent list'[name],
    'Agent list'[User login],
    "Top 10 t-wait", [Top 10 t-wait]
)

It gives me the right results. But now I need count the occurences of values ("Agent list"[name]). So I have virtual table:

Date	Name	User login	Top 10 t-wait
1.3.2021	John	jo123	02:33:14
3.3.2021	John	jo123	04:56:39
1.3.2021	Mark	ma456	05:23:23
2.3.2021	Mark	ma456	06:23:45
3.3.2021	Mark	ma456	02:22:34
7.3.2021	Adam	ad789	02:45:45
7.3.2021	Adam	ad789	01:45:56

The results shout be like:
Name  Count

John    2

Mark   3

Adam  2

Can you help me please?

Thank you

[Anonymous]

@Fiala 

I understand you want a separate table with Name and Count. Once you've created the first table, table1, you can create a second one like this:

[Table2] =
SUMMARIZECOLUMNS(
    table1[Name],
    "Count",
        CALCULATE(
            COUNTROWS( table1 )
        )
)

[Anonymous]

Hello @Fiala ,
You can use a measure.
Total Count = Count('Table'[Name])
If it's not expected then please share the pbix file after removing the sensitive data.

[Jihwan_Kim]

Hi, @Fiala 

Please correct me if I wrongly understood your question.

I think you can just write like,

measure = countrow (table1)

Or, if it is OK with you, please share your sample pbix file, then I can try to understand more clearly.

Thank you.

Hi, My name is Jihwan Kim.

If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.