Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
Hi there
I have a pretty basic PowerBI report, which includes completion rates of a certain task within a PowerApp, which is patched to a Dataverse table.
The columns I am wanting to use here are all the colleagues where action is required by their manager, the action completion status (either 'Completed' or 'Incomplete') and then another column which gives the colleague&leader's Department.
I would like to create a leaderboard to show, in desending order, who has completed the most tasks (so where the Count of colleagues per department has an action completion status column value of 'Completed'), to try and gamify what is a pretty boring job for our business.
As a mock up in Excel of what I am trying to achieve in PBI is like this...
All help appreciated
Thanks
K.
Solved! Go to Solution.
Hi, @Kosenurm
Try formula as below:
Percent complete =
VAR _completed =
CALCULATE (
COUNTROWS ( 'Table' ),
FILTER (
ALLEXCEPT ( 'Table', 'Table'[Department] ),
'Table'[Status] = "Completed"
)
)
VAR _total =
CALCULATE ( COUNTROWS ( 'Table' ), ALLEXCEPT ( 'Table', 'Table'[Department] ) )
RETURN
_completed / _total
Then apply this filed to a table visual and sort by this field
Best Regards,
Community Support Team _ Eason
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
@Kosenurm , Not very clear on the ask?
If you need a measure it would be like
divide( Countrows(Filter(Table, Table[Status]= "Completed")), Countrows(Table))
Apologies.
A table which shows completion with highest completion percentage first.
Thanks
K
Hi, @Kosenurm
Try formula as below:
Percent complete =
VAR _completed =
CALCULATE (
COUNTROWS ( 'Table' ),
FILTER (
ALLEXCEPT ( 'Table', 'Table'[Department] ),
'Table'[Status] = "Completed"
)
)
VAR _total =
CALCULATE ( COUNTROWS ( 'Table' ), ALLEXCEPT ( 'Table', 'Table'[Department] ) )
RETURN
_completed / _total
Then apply this filed to a table visual and sort by this field
Best Regards,
Community Support Team _ Eason
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
111 | |
105 | |
105 | |
88 | |
61 |
User | Count |
---|---|
165 | |
133 | |
132 | |
95 | |
86 |