cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
alopez Regular Visitor
Regular Visitor

Re: Help!!! Measure Dax

Hi @AlB,

 

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

Community Support Team
Community Support Team

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

Community Support Team _ Cherie Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
alopez Regular Visitor
Regular Visitor

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

Highlighted
Community Support Team
Community Support Team

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

 

Community Support Team _ Cherie Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.