Forum Discussion

alhashmi's avatar
alhashmi
New Member
6 years ago

Duplicate Graph With Different Results

Hello,

 

https://i.imgur.com/cTCpNkb.png (Please use the link to see the mentioned graphs)

 

Could anyone explain why is graph 2 not showing the nº of "Done by" and "Checked by" by SLA? It was done the exact same way as graph 1 but, somehow, the result is different. I have tried to create a copy of the tables "Check" and "Table" and create a similar relationship with "SLA" as it was done with "People" but it did not work either.

 

Thank you very much for your help in advance.

3 Replies

  • AllisonKennedy's avatar
    AllisonKennedy
    Community Champion
    What is the purpose of the 'Check' table? This does not link currently to your main 'Table' and has no relationship to SLA since there's no SLA column in the Check table. If you remove "Count of Checked By" from the SLA graph does it behave a bit better? It should.

    If you can explain the logic around how 'Checked By' is calculated, we can help you create a measure to calculate this against SLA, but with your current data model it won't work.
  • alhashmi , This SLA table value, do not have ant kind of white space or something.

     

    Check like. In Table create a new column

    New Column = related(SLA[SLA])

    for all the columns you should get a value Same as what you have in SLA column of Table.  If you are not getting, please correct the values either in SLA table or in Table for SLA column.

  • Icey's avatar
    Icey
    Community Support

    Hi alhashmi ,

     

    I can't reproduce your issue. Please modify the .pbix file I uploaded according to your situation.

     

     

     

    Best Regards,

    Icey

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.