Forum Discussion
Help with DAX
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 |
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
2 Replies
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.biHi Denis, this is genius! I used your measure to calculate On Time Delivery excluding sites with Missing LRD. Thank you lots!
