I have a task to create a graph table to include columns from many different tables connected to each other on power bi using relationships.
I'll try to elaborate as much as I can,
tables used to build this graph:
Internal Line table
Users + sites
the table should include all user info (name, site,...) + count of calls this user made, if this user did not make any calls it should also be shown in the same table as this user is considered an inactive user, so I've created a measure from the call table to count calls. if the measure = "call number count =
DISTINCTCOUNT('call'[call.id]) + 0"
I've added the " + 0 " to show also users with 0 calls
this example is ok with me and this is what is requested, but I need to add 3 additional column from different tables (country name instead of the country code)
this is the relationship
the issue is when I add the "requesting Country" column to the above table the table shows all existing countries in the "requesting country" table with 0 values, I need onlyto show the related country
the result is :
I need to show the related country only, if I remove the " +0 " from the measure it shows only matching records but remove the inactive user