Forum Discussion

ArchStanton's avatar
ArchStanton
Icon for Power Participant rankPower Participant
2 years ago
Solved

Small discrepancies in Total YTD using same measure

Hi,   I hope someone can shed some light and help me with this issue, unfortunately I cannot share the pbix for security reasons but hopefully someone can give me one or two pointers as to what is ...
Need Help
Show and Tell
  • ArchStanton's avatar
    ArchStanton
    2 years ago

    I'm not sure whats happening either, I inherited this beast of a datamodel over 2 yrs ago. I have so many date columns in my main fact table, as soon as i try to create inactive relationships like you suggest the entire report breaks down. Everything was built on the Created On date > Date2.Date field.
    Anyway, I've split the visual into two and started again - my numbers in black add up to 5,017 and are correct now.

     

     

     

    Thanks for your help, much appreciated...


ArchStanton's avatar
ArchStanton
Icon for Power Participant rankPower Participant
2 years ago

This is not cumulative so the numbers should not always increase. Its the black 'closed' bars that are the problem, the green ones are fine

 

Ps I cannot create an inactive relationship like you suggest in your code as it breaks multiple visuals and slicers in my report

johnt75's avatar
johnt75
Icon for Super User rankSuper User
2 years ago

I don't understand how an inactive relationship can affect anything. Until you specifically activate it using USERELATIONSHIP it is as though it doesn't exist. Are you sure it was inactive ?

  • ArchStanton's avatar
    ArchStanton
    Icon for Power Participant rankPower Participant
    2 years ago

    I'm not sure whats happening either, I inherited this beast of a datamodel over 2 yrs ago. I have so many date columns in my main fact table, as soon as i try to create inactive relationships like you suggest the entire report breaks down. Everything was built on the Created On date > Date2.Date field.
    Anyway, I've split the visual into two and started again - my numbers in black add up to 5,017 and are correct now.

     

     

     

    Thanks for your help, much appreciated...


    • Anonymous's avatar
      Anonymous
      Not applicable
      2 years ago

      Hi, ArchStanton 

      It looks like you have found a solution. Could you please mark this helpful post as “Answered”?

      This will help others in the community to easily find a solution if they are experiencing the same problem as you.

      Thank you for your cooperation!

       

       

       

      I hope my suggestions give you good ideas, if you have any more questions, please clarify in a follow-up reply.
      Best Regards,
      Fen Ling,
      If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.