Forum Discussion

tabuzahra's avatar
tabuzahra
Icon for Helper II rankHelper II
6 years ago

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 th...
Need Help
mwegener's avatar
mwegener
Icon for Most Valuable Professional rankMost Valuable Professional
6 years ago

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's avatar
    tabuzahra
    Icon for Helper II rankHelper II
    6 years ago

    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's avatar
      mwegener
      Icon for Most Valuable Professional rankMost Valuable Professional
      6 years ago

      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.