Help!!! Measure Dax

[Anonymous]

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?"

[chrispybacon]

Maybe this helps

Measure =
(SUM(
    actualhours) * Distinctcount(Employee))

[Anonymous]

this is the result of that formula 

[AlB]

the SUM on @chrispybacon's code is only for the first column.

Measure =
SUM(actualhours) * Distinctcount(Employee)

[Anonymous]

Hi @AlB,

Still its not working. 😞 but thanks for trying to help me

[v-cherch-msft]

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

[Anonymous]

Hi @v-cherch-msft thank you for helping me but the results are not correct.

See screenshot below. Thank you!

 

[v-cherch-msft]

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

[HotChilli]

Show us your measure formula

[Anonymous]

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]

[AlB]

Hi @Anonymous

What is the code of your measure?

[Anonymous]

Hi @AlB,

Actually, I don't know what is the correct code for this 😞 I'm a newbie. Thanks for the reply!

[AlB]

@Anonymous

What is the operation exactly, with the names of the columns in your data?

[Anonymous]

its [ActualWorkingHoursMonthly] * [count of EmployeeName]