Duplicate Graph With Different Results

[alhashmi]

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.

[Icey]

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.

[amitchandak]

@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.

[AllisonKennedy]

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.