Skip to main content
cancel
Showing results for
Search instead for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Regular Visitor

## Create a leaderboard based on Dataverse column value

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.

1 ACCEPTED SOLUTION
Community Support

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.

3 REPLIES 3
Super User

@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))

Regular Visitor

Apologies.

A table which shows completion with highest completion percentage first.

Thanks

K

Community Support

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.

## Helpful resources

Announcements

#### Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

#### Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

#### New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

Top Solution Authors
Top Kudoed Authors