Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi Guys,
please help. I would like to create a measure wherein I will calculate the [# of hours] * [# of Employees] but I got this problem
"Got an error: The expression refers to multiple columns. Multiple columns cannot be converted to a scalar value?"
Maybe this helps
Measure = (SUM( actualhours) * Distinctcount(Employee))
this is the result of that formula
the SUM on @chrispybacon's code is only for the first column.
Measure = SUM(actualhours) * Distinctcount(Employee)
Hi @Anonymous
You may try below measure. If it is not your case, could you explain more about your expected output with below sample data?
Measure = SUMX(BillableNonResource,BillableNonResource[ActualWorkingHoursMonthly]*DISTINCTCOUNT(BillableNonResource[EmployeeName]))
Regards,
Cherie
Hi @v-cherch-msft thank you for helping me but the results are not correct.
See screenshot below. Thank you!
Hi @Anonymous
Not sure about your expected output. But you may try below measure.
test = SUM ( BillableNonResource[ActualDays] ) * COUNTROWS ( SUMMARIZE ( BillableNonResource, BillableNonResource[Employee], BillableNonResource[Month] ) )
Regards,
Cherie
Show us your measure formula
Hi @HotChilli,
Actually I'm not sure what formula or code I will use.
I want to get the value of [# of ActualWorkigHoursMonthly] * [Total # of Employees]
Hi @Anonymous
What is the code of your measure?
Hi @AlB,
Actually, I don't know what is the correct code for this 😞 I'm a newbie. Thanks for the reply!
@Anonymous
What is the operation exactly, with the names of the columns in your data?
its [ActualWorkingHoursMonthly] * [count of EmployeeName]
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
97 | |
80 | |
69 | |
59 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |