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.
Hi,
Trying to count the number of CarerRef if the StartDate was before the date in a related table.
Trying -> Count Carer Ref = CALCULATE(COUNTROWS(CarersList),CarersList[CarerRef],CarersList[StartDate] < RELATEDTABLE(vw_ShiftsAll),vw_ShiftsAll[iDate])
Getting error The expression refers to multiple columns. Multiple columns cannot be converted to a scalar value.
Any ideas what I need to change?
Solved! Go to Solution.
Hi @android1
Please give this calculated column a go.
Column = CALCULATE( COUNTROWS('vw_ShiftsAll'), 'vw_ShiftsAll'[iDate] > EARLIER('CarersList'[StartDate]) )
Hi @android1
Do you want this to be a calculated column or calculated measure?
Which table is on the One side of the one-to-many relationship between 'CarersList' and 'vw_ShiftsAll' ?
Hi @android1
Please give this calculated column a go.
Column = CALCULATE( COUNTROWS('vw_ShiftsAll'), 'vw_ShiftsAll'[iDate] > EARLIER('CarersList'[StartDate]) )
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
85 | |
82 | |
65 | |
62 | |
55 |
User | Count |
---|---|
171 | |
111 | |
110 | |
72 | |
71 |