Forum Discussion

ArchStanton's avatar
ArchStanton
Icon for Power Participant rankPower Participant
1 year 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
    1 year 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
1 year ago

Thanks John, I'll give that a go but before I do, I just noticed that a Page Filter that excludes Team L is being ignored in my bar chart. There were 875 closures in July but my bar chart above shows 876, why do you think the page filter seems to be working on one visual but not the other?

johnt75's avatar
johnt75
Icon for Super User rankSuper User
1 year ago

I'm not sure, but something strange appears to be going on. I would expect the YTD value to always increase month-on-month, but it doesn't. It decreases in August then again in October. Try using the code I posted, and change the axis of the graph to the date table and then lets see what the numbers look like.

  • ArchStanton's avatar
    ArchStanton
    Icon for Power Participant rankPower Participant
    1 year 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
      1 year 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
        1 year 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...