Reply
Regular Visitor
Posts: 44
Registered: ‎06-29-2016

Re: Help!!! Measure Dax

Hi @AlB,

 

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

Community Support Team
Posts: 860
Registered: ‎07-25-2018

Re: Help!!! Measure Dax

Hi @alopez

 

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]))

1.png

 

Regards,

Cherie

Regular Visitor
Posts: 44
Registered: ‎06-29-2016

Re: Help!!! Measure Dax

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

 

See screenshot below. Thank you!

 

 TEST.png

Community Support Team
Posts: 860
Registered: ‎07-25-2018

Re: Help!!! Measure Dax

Hi @alopez

 

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