The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hi there. Likely a newb question, and I don't even know if I'm on the right track here, but I'm basically trying to get a count of tasks in a "tasks" table where related opportunity status in "opportunities" table = "won". This is what I'm trying:
COUNTX(filter(enhancedopportunity,enhancedopportunity[StateCodevalue]="Won"),enhancedtask[MeasureCountTasks])
but I seem to be getting the following error:
"Function 'COUNTX' is not supported in this context in DirectQuery mode."
My end goal is to get a % total of tasks where regarding opportunity status = "won"... or % of total tasks that result in won opportunities and my thought was to keep it simple by getting counts in two new columns and then divide one column by the other. There may be another way to accomplish this that my newbie brain can't fathom 🙂
Any help would be greatly appreciated. Thanks!
Solved! Go to Solution.
You may just replace enhancedtask[MeasureCountTasks] with number 1.
You may just replace enhancedtask[MeasureCountTasks] with number 1.
User | Count |
---|---|
78 | |
73 | |
38 | |
30 | |
28 |
User | Count |
---|---|
107 | |
100 | |
55 | |
49 | |
45 |