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.
New to Power BI and this forum.
Not sure if this was supposed to ask this question in this group or the visuals group.
I have multiple employees in a employee table that shows what team they belong to. I want to have a card on an employee dashboard that shows the percentage of tickets they have completed based off the total tickets that team has completed. The percentage will show on the card based off who is selected in the slicer.
Slicer will have each employees name from all teams
The [Employee Table] has more than just these two columns but is simplified for this post
The [Ticket Table] has the tickets assigned to each of the employees:
Desired result will be a card that shows the percentage of employee's tickets against their respective team's tickets based on whoever is selected in the slicer
Example:
If Bob is selected, the card will show 40%
If Larry is selected, the card will show 60%
etc.
Solved! Go to Solution.
Hi,
Please check the below picture and the attached pbix file.
% ticket complete: =
VAR _ticketbyname =
COUNTROWS ( VALUES ( ticket[ticket#] ) )
VAR _ticketbyteam =
CALCULATE (
COUNTROWS ( VALUES ( ticket[ticket#] ) ),
ALL ( employee[name] ),
VALUES ( employee[team] )
)
RETURN
IF (
HASONEVALUE ( employee[name] ),
DIVIDE ( _ticketbyname, _ticketbyteam ),
"select name"
)
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,
Please check the below picture and the attached pbix file.
% ticket complete: =
VAR _ticketbyname =
COUNTROWS ( VALUES ( ticket[ticket#] ) )
VAR _ticketbyteam =
CALCULATE (
COUNTROWS ( VALUES ( ticket[ticket#] ) ),
ALL ( employee[name] ),
VALUES ( employee[team] )
)
RETURN
IF (
HASONEVALUE ( employee[name] ),
DIVIDE ( _ticketbyname, _ticketbyteam ),
"select name"
)
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 |