cancel
Showing results for
Did you mean:
Helper II

## Matrix Row Total Is Wrong

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:

6 REPLIES 6
Super User III

## Re: Matrix Row Total Is Wrong

Hi @tabuzahra ,

can you share sample data and your measure?

Regards,

Marcus

Dortmund - Germany

Please mark my post as solution, this will also help others.

I work at KUMAVISION AG , one of the world's largest
implementation partners for Microsoft Dynamics. #BetterTogether

Helper II

## Re: Matrix Row Total Is Wrong

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]))
Super User III

## Re: Matrix Row Total Is Wrong

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

Please mark my post as solution, this will also help others.

I work at KUMAVISION AG , one of the world's largest
implementation partners for Microsoft Dynamics. #BetterTogether

Community Support

## Re: Matrix Row Total Is Wrong

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!

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

## Re: Matrix Row Total Is Wrong

Hello,

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

Super User III

## Re: Matrix Row Total Is Wrong

Hi @tabuzahra ,

PBIX

Please mark my post as solution, this will also help others.

I work at KUMAVISION AG , one of the world's largest
implementation partners for Microsoft Dynamics. #BetterTogether

Announcements

#### Announcing the New Spanish Forum

Do you need help in Spanish? Check out our new Spanish community section.

#### April 2020 Community Highlights

Info on our Super Users, MBAS content and badges, and updates to our support articles. - Read the full Community Highlights.

#### MBAS Gallery 2020

Watch Microsoft Business Applications Summit sessions on-demand.

Top Solution Authors
Top Kudoed Authors