Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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
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 )
)
)
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.
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.
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
User | Count |
---|---|
69 | |
43 | |
21 | |
20 | |
14 |
User | Count |
---|---|
123 | |
42 | |
39 | |
26 | |
24 |