Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi,
I have a scenario below where a course (object.name) has 2 records in the table. First record which was accessed (In-progress) by an user (actor.mbox) and later has completed it. I am trying to get a count of all courses that were still In-progress but never got completed by an user. Can someone assist me in getting the right expression to pass ?
“Inprogress Courses” = CALCULATE(DISTINCTCOUNT('Brand Excellence Academy_all'[object.name]),'Brand Excellence Academy_all'[verb.display]="accessed",'Brand Excellence Academy_all'[object.type]="course")
Requirement: Should also filter out courses if they are completed
“Completed Courses” = CALCULATE(DISTINCTCOUNT('Brand Excellence Academy_all'[object.name]),'Brand Excellence Academy_all'[verb.display]="completed",'Brand Excellence Academy_all'[object.type]="course")
Above expresssion works well for completed but “Inprogress Courses” should not take into count for those courses which are completed by an user.
Any help is really appreciated.
Thanks
Solved! Go to Solution.
You can subtract the two. For eg: Inprogress - Completed so if any course gets completed then it will get subtracted from in progress.
You can subtract the two. For eg: Inprogress - Completed so if any course gets completed then it will get subtracted from in progress.
I am sorry, but i am new to DAX, can you use my expression above for "In-Progress" to modify and send it here.
Really appreciate your assistance !
I think i got it to work, used below expression and it worked.