Measure that shows percentage of not overdue tasks

Sonnet — Wed, 28 Feb 2024 22:35:33 GMT

HI all,

I have a measure that shows the count of not overdue tasks. I need it to show the percentage instead.

This is the measure:

Not OverdueTasks = CALCULATE( COUNTROWS('Sheet1'), FILTER( 'Sheet1', 'Sheet1'[Overdue] = FALSE() ) )+0

I need it in percentage to show it in a KPI visual.

The KPI should compare data from previous year. Could you also check that the target measure is correct please?

Prev1Year = CALCULATE([Not OverdueTasks], PARALLELPERIOD('Calendar'[Date],-1,YEAR))

Sample Data:

ID	Name	Opening Date	Completion Date	Task Type
PT00001	Name 00001	24/08/2023	01/02/2024	Project
PT00002	Name 00002	11/09/2023	28/02/2024	Task
PT00003	Name 00003	22/09/2023	24/12/2023	Assignment
PT00004	Name 00004	13/10/2023		Support Ticket
PT00005	Name 00005	11/09/2023	09/01/2024	Project
PT00006	Name 00006	06/10/2023	18/10/2024	Task
PT00007	Name 00007	19/10/2023	02/02/2024	Assignment
PT00008	Name 00008	16/11/2023	20/11/2023	Support Ticket
PT00009	Name 00009	17/11/2023		Project
PT00010	Name 00010	20/11/2023	21/11/2023	Support Ticket
PT00011	Name 00011	21/11/2023	01/12/2023	Support Ticket
PT00012	Name 00012	22/11/2023	22/11/2023	Support Ticket
PT00013	Name 00013	09/12/2023		Project
PT00014	Name 00014	24/12/2023	09/01/2024	Task
PT00015	Name 00015	18/01/2024		Assignment
PT00016	Name 00016	20/01/2024	28/01/2024	Support Ticket
PT00017	Name 00017	10/01/2024	20/01/2024	Support Ticket
PT00018	Name 00018	31/01/2024	11/04/2024	Task
PT00019	Name 00019	22/02/2024		Assignment

Because I can't upload a .pbix file, I add other formula to help you build the data set as in my .pbix file.

Expected_Completion_Date =

SWITCH (

'Sheet1'[Task Type],

"Project", 'Sheet1'[Opening Date] + 180,

"Assignment", 'Sheet1'[Opening Date] + 90,

"Task", 'Sheet1'[Opening Date] + 14,

"Support Ticket", 'Sheet1'[Opening Date] + 3,

BLANK ()

)

Overdue = IF(ISBLANK([Completion Date]), TODAY() > [Expected_Completion_Date], [Completion Date] > [Expected_Completion_Date])

Any help is much appreaciated.

Re: Measure that shows percentage of not overdue tasks

Anonymous — Thu, 29 Feb 2024 08:40:56 GMT

Hi Sonnet ,

After my testing, I found that the percentage cannot be directly dragged into the KPI visual for display.

If you want to learn more about KPI visuals, please see:

Key Performance Indicator (KPI) visuals - Power BI | Microsoft Learn

If you want to display ‘Not OverdueTasks’ as a percentage, please try:

NotOverdueTasks = FORMAT(DIVIDE( CALCULATE( COUNTROWS('Sheet1'), FILTER( 'Sheet1', [Overdue] = FALSE() )), CALCULATE(COUNTROWS('Sheet1'),ALL(Sheet1)) ), "Percent")

I have not found any problems with your 'Prev1Year' for the time being, and the logic is correct.

If you have any further questions please feel free to contact me.

pbix file is attached.

Best Regards,
Yang
Community Support Team

If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

topic Measure that shows percentage of not overdue tasks in DAX Commands and Tips

Measure that shows percentage of not overdue tasks

Re: Measure that shows percentage of not overdue tasks