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.
I want to be able to have a card that reports on repeat callers.
The table basically looks like this:
The CLI column is the users phone number, I wanted to be able to count how many times someone has called more than 5 times in a day. Then have a card that can report '25 people called more than 5 times in a day' I have a date table and slicers so hopefully this would the update to reflect that.
I know how to distict count to see how many unique callers, and also I managed to add a column which showed how many times that person had called in total. But not a way to just simplify it to be be X called >5 times.
I'm struggling with how to do this at the moment though, any help would be greatly appreciated.
Solved! Go to Solution.
Hi @MatH
Please try
More Than 5 Calls =
VAR T1 =
SUMMARIZE (
TableName,
TableName[CLI],
TableName[Date],
"@NumberOfCalls", COUNTROWS ( TableName )
)
VAR T2 =
FILTER ( T1, [@NumberOfCalls] > 5 )
VAR T3 =
SELECTCOLUMNS ( T2, "@CLI", TableName[CLI] )
VAR Result =
COUNTROWS ( DISTINCT ( T3 ) )
RETURN
Result & "people called more than 5 times in a day"
Hi,
I tried to create a sample pbix file like below.
I hope the below can provide some ideas on how to create a solution for your data model.
Please check the below picture and the attached pbix file.
expected measure: =
COUNTROWS (
FILTER (
ADDCOLUMNS (
VALUES ( Data[CLI] ),
"@callcountperday", CALCULATE ( COUNTROWS ( Data ) )
),
[@callcountperday] > 4
)
)
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.
Hi @MatH
Please try
More Than 5 Calls =
VAR T1 =
SUMMARIZE (
TableName,
TableName[CLI],
TableName[Date],
"@NumberOfCalls", COUNTROWS ( TableName )
)
VAR T2 =
FILTER ( T1, [@NumberOfCalls] > 5 )
VAR T3 =
SELECTCOLUMNS ( T2, "@CLI", TableName[CLI] )
VAR Result =
COUNTROWS ( DISTINCT ( T3 ) )
RETURN
Result & "people called more than 5 times in a day"
Thank you, I've just tried testing it and it seems to have worked perfectly. Much appreciated
User | Count |
---|---|
84 | |
71 | |
71 | |
68 | |
55 |
User | Count |
---|---|
94 | |
92 | |
91 | |
77 | |
70 |