Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
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
@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)
User | Count |
---|---|
97 | |
85 | |
77 | |
66 | |
62 |
User | Count |
---|---|
110 | |
95 | |
95 | |
64 | |
58 |