Help with DAX

[Oana]

I am just starting to learn DAX and need help to calculate On Time Delivery %  excluding a specific category: in Time Peformance I want to exclude "Missing LRD".

The table shows: projects listed by an unique number, a Submit date (completion date of the project) and status (A for completed), a Required date (the target date to complete the project), a calculated column Time Peformance (which compares the Submit date and Required date and assigns a category), Employee. I want to calculate On Time Delivery % to show how many projects were completed On Time for each Employee, but exclude the "Missing LRD" category projects, because for that category there is no Required date.         

Project ID	Submit Date	Submit Status	Required Date	Time Performance	Employee
505924	3/5/2021	A	7/15/2021	On Time	JJ
505929	2/4/2021	A	9/23/2020	91-180 Days Late	JJ
487955	1/26/2021	A	1/29/2021	On Time	FG
487958	2/24/2021	A	12/18/2020	31-90 Days Late	FG
488323	2/25/2021	A		Missing LRD	EP
488099	1/28/2021	A	12/28/2020	31-90 Days Late	DV
481229	1/27/2021	A	3/10/2021	On Time	DV
481229	1/26/2021	A	1/22/2021	1-30 Days Late	DV
506405	1/29/2021	A	8/5/2021	On Time	MP
506405	3/1/2021	A	2/14/2021	1-30 Days Late	MP
506405	3/1/2021	A		Missing LRD	DA
506406	2/27/2021	A	2/25/2021	1-30 Days Late	MP
506433	3/11/2021	A	2/1/2021	31-90 Days Late	MP
487880	3/4/2021	A	10/30/2018	Over 180 Days Late	SV

[selimovd · Accepted solution]

Hey @Oana ,

try with Calculate:

Project without Missing LRD = CALCULATE( COUNTROWS( myTable ), myTable[Performance] <> "Missing LRD" )

If you need any help please let me know.
If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍

Best regards
Denis

Blog: WhatTheFact.bi

[Oana]

Hi Denis, this is genius! I used your measure to calculate On Time Delivery excluding sites with Missing LRD. Thank you lots!