Count course names where learners not in progress

[SBR1D]

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

[SBR1D]

thank you very much - sorry for the late reply

[ryan_mayu]

you are welcome

[Idrissshatila]

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 💡

[SBR1D]

I 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

[SBR1D]

Can anyone help please?

[ryan_mayu · Accepted solution]

@SBR1D 

maybe you can try this

Measure = 
var TBL=DISTINCT(SELECTCOLUMNS(FILTER('Table','Table'[Status]="In progress"),"Course name",'Table'[Course name]))
VAR tbl2=DISTINCT('Table'[Course name])
var tbl3=EXCEPT(tbl2,TBL)
return COUNTROWS(tbl3)

pls see the attachment below