Forum Discussion

ThomasWeppler's avatar
ThomasWeppler
Icon for Impactful Individual rankImpactful Individual
3 years ago

Don't show blank values while looking up multiple sources.

Hi Power BI community,

I have a matrix that shows all my customers (customer[name]) and all the employees that work service this customer (user[name])
All the customers pays a subscription each month. The table we get this information from is connected to customers, but not users.

All customers have a specific amount of services each month that is connected to the user table. 

I want two filters

1. A filter that removes all the employees that doesn't wrok on a specifik customer.
2. A filter that removes all customers with no services and no subscription.

 

My problem is that if I just make a filter that removes all employees that doesn't work on a specific customer I also end up removing all the customers without any service check up but which still have a subscription. Any suggestions on what I should do here?

 

All help is greatly appreciated.

 

Need Help

2 Replies

  • AlanP514's avatar
    AlanP514
    Icon for Post Patron rankPost Patron
    3 years ago

    Hi Can you pleasee avoid sensistive data and share the pbix file here

  • ThomasWeppler's avatar
    ThomasWeppler
    Icon for Impactful Individual rankImpactful Individual
    3 years ago

    Hi AlanP514 unfortunately
    I cannot share the pbix file.

    But I can try to give a bit more information

    tabel 1

    Customer

    Index = index

    customerid = a uniq id for each customer

    customername = the name of the customer

     

    Table 2

    User

    Index = index

    Userid = a uniq id for each user

    Username = the name of the user

     

    Table 3 

    Subscription
    Index = An index
    Date = the date of an transaction

    Customerid = the customer who made the transaction is the same as customerid in the customer table

    Amount = the monetary amount of the transaction

     

    Table 4

    Service
    Index = the index

    Date = the date the serivce was carried out

    Customerid = the customer the service was carried out for (same id as in the custoemr table)

    Userid = the user who carried out the service.

    I hope this is enough otherwise feel free to ask again.