Forum Discussion
Helper IIICount course names where learners not in progress
Hi All
So i want a distinct count of courses where the status is <> In progress
So the count should total to 4
This is what i have tried but i get " a function "PLACEHOLDER" has been used in a true/false expression that is used as a table expression.
I am not sure what to do from here?
Please help
distinct count course not active = CALCULATE(DISTINCTCOUNT('Table'[Course Name]),[Learners in progress]=0)
Learners in progress = CALCULATE(COUNTA('Table'[LearnerId]),('Table'[Status]="In Progress"))
| LearnerID | Course name | Status |
| 1 | math | In progress |
| 2 | english | In progress |
| 3 | history | Completed |
| 4 | geography | Withdrawn |
| 5 | math | Completed |
| 6 | math | Withdrawn |
| 7 | english | In progress |
| 8 | IT | Completed |
| 9 | history | Withdrawn |
| 10 | math | Completed |
6 Replies
- Idrissshatila
Super User
Hello SBR1D ,
this is the measure
Measure = CALCULATE(DISTINCTCOUNT('YourTableName'[Course name]),'YourTableName'[Status] <> "In Progress")If I answered your question, please mark my post as solution, Appreciate your Kudos 👍
Follow me on Linkedin
Vote for my Community Mobile App Idea 💡
SBR1DI realise i have explained this incorrectly but thank you for the initial solution.
What i need to do is if there are no "in progress" status then do distinct count.
e.g. math has 4 status, 1 in progress , 2 completed and 1 withdrawn, because it has 1 in progress do not count it.
So the final count should be 3 as there 3 courses with no status = in progress and they are History, Geography and IT.
Thanks in advance
- SBR1DCan anyone help please?
- SBR1D
thank you very much - sorry for the late reply
ryan_mayuyou are welcome
