Matrix Row Total Is Wrong

[tabuzahra]

Dears,

Thank you for usual support. Lovely Community!

Kindly, I have the below challenge and I'm seeking for your help and support

I have a matrix where it shows each date timesheet hours that have been logged for each employee. The values are correctly showing in each cell, where it shows also V in case the employee has taken a vacation on that day. Though the row subtotal are showing incorrectly in case there is a V in an employee who has taken a vacation on any date, where I want it to show his total hours that he has logged and ignoring the V values. Below is an image:

[v-diye-msft]

Hi @tabuzahra 

If you've fixed the issue on your own please kindly share your solution. if the above posts help, please kindly mark it as a solution to help others find it more quickly.thanks!

[tabuzahra]

Hello,

Sorry, but I still haven't solved yet neither the mentioned solution worked out.

[mwegener]

Hi @tabuzahra ,

please check this.

PBIX

[mwegener]

Hi @tabuzahra ,

can you share sample data and your measure?

Regards,

Marcus

Dortmund - Germany
If I answered your question, please mark my post as solution, this will also help others.
Please give Kudos for support.

[tabuzahra]

Hi Mwegener,

Thanks for your response. Below you can find a link with the sample data as well as the measures that I'm using:

Sample Data

Leave Hours & Vacations = if([Leaves - V]<>"V" ,[OTL Hrs Sum],'HR Leaves'[Leaves - V] )

Leaves - V = CALCULATE(if([Leave Without Weekends In Days]>=1,"V",[OTL Hrs Sum]),USERELATIONSHIP('HR Leaves'[Vacation Date],'Calendar'[Date]))

[mwegener]

Hi @tabuzahra,

try this as quick and dirty solution.

Leaves - V = CALCULATE(if([Leave Without Weekends In Days]>=1 && [OTL Hrs Sum] = 0 ,"V",[OTL Hrs Sum]),USERELATIONSHIP('HR Leaves'[Vacation Date],'Calendar'[Date]))

Regards,

Marcus

Dortmund - Germany
If I answered your question, please mark my post as solution, this will also help others.
Please give Kudos for support.