Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric 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 |
---|---|
80 | |
74 | |
63 | |
61 | |
45 |
User | Count |
---|---|
108 | |
98 | |
89 | |
82 | |
61 |