Forum Discussion

anwarbi's avatar
anwarbi
Helper III
4 years ago
Solved

Filtering a column based on a value from another column

Hi,   I am trying to filter my dataset based on certain conditions, consider the below example.   Lets say the below Table 1 is my dataset. what i am trying to do is: If in the 'Company' column ...
Need Help
  • NickolajJessen's avatar
    NickolajJessen
    4 years ago

    Haha, what a fun requirement. Here's my take:

    Create a disconnected lookup table containing the company names. This will be used to populate the variable _Company in the measure, without filering our data.

    The _Company variabl collects all companies, that a specific worker is related to.

    The result checks, if the selected Company from the Disconnected Lookup is present in the _Companies variable 

     


    EDIT: 
    A few more arrows for clarification:

     

NickolajJessen's avatar
NickolajJessen
Solution Sage
4 years ago

Haha, what a fun requirement. Here's my take:

Create a disconnected lookup table containing the company names. This will be used to populate the variable _Company in the measure, without filering our data.

The _Company variabl collects all companies, that a specific worker is related to.

The result checks, if the selected Company from the Disconnected Lookup is present in the _Companies variable 

 


EDIT: 
A few more arrows for clarification:

 

anwarbi's avatar
anwarbi
Helper III
4 years ago

Hi NickolajJessen 

 

This solution does work on 'Table' visual but when I use 'Bar chart' visual to calculate lets say Average hours and count of names, then despite having the measure filter of 1 applied on the visual, it still calculates the total count of names.

 

I have attached the sample power bi file, basically I am looking to include the same data in Bar chart as in the table, e.g. In table there are 3 distinct count of names so I want to see the same count in Bar chart as well. 

 

Thanks,