How to Return Specific Percentage if values are present or not in a column

[jovendeluna21]

Hello,

Any idea on how can I return a percentage if specific values are only available.

For example, if the username have this 3 courses (PE 105, PE 110, PE 115) in column "Course Name", it will return as 100%, if only 2 of the said courses then 67%, if only 1 of the said courses then 33% and if no of the said courses then 0%.

I have attached here the pbi file. Thank you!

https://drive.google.com/file/d/1ApquCh69uDWJIBQ69sf7Mx5Z6Ne3Iv2L/view?usp=sharing

[jovendeluna21]

Hello, I just want to check the completion if these 3 courses PE 105, PE 110, PE 115 are present, then I want to have a column that will say it's1 and if does complete then 0

[amitchandak]

@jovendeluna21 , A measure like

divide(distinctcount(Table[Course Name]), 3,0)

divide(distinctcount(Table[Course Name]), 3,0)+0

or

divide(distinctcount(Table[Course Name]), calculate(distinctcount(Table[Course Name]), all(Table)) ,0)