Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It 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]) )
User | Count |
---|---|
101 | |
90 | |
80 | |
71 | |
69 |
User | Count |
---|---|
114 | |
97 | |
97 | |
73 | |
72 |