Forum Discussion

mshamsiev's avatar
mshamsiev
Helper I
9 years ago
Solved

Cross Data Filtering

Hi everyone!   I have three separate data sources (active, closed, opened) jobs. Each one has a column which lists the Task Type (ie. incident, request etc).    What I'm trying to do is create a ...
  • mshamsiev's avatar
    mshamsiev
    9 years ago

    Hi Phil_Seamark and Anonymous,

     

    Thanks again for the help. I ended up recreating the initial data table to overcome the issue. 

     

    See you guys around the forums! 

     

    -Mike 

Phil_Seamark's avatar
Phil_Seamark
Microsoft Employee
9 years ago

Hi mshamsiev

 

Do you combine your datasources in any way or are these three separate tables in Power BI, each with a many to one relationship to the Task Type table?

 

It sounds like you are on the right track.  Please also double check that all the columns used on both sides of each relationship are the same datatype.

 

 

mshamsiev's avatar
mshamsiev
Helper I
9 years ago

Hi Phil_Seamark,

 

Thanks for the reply! All three datasources are separate tables. They all have columns which include 'assignment group' 'task type' and 'date'. So I created three further tables containing each of those variables and matched them. Do I need to combine them?

 

Much appreciated.

 

-Mike  

  • Phil_Seamark's avatar
    Phil_Seamark
    Microsoft Employee
    9 years ago

    Hi mshamsiev

     

    You don't need to combine them, but if they are as similar as it sounds like, it will make filtering and other measures easier if they are in the same table.  

     

    You can do this in DAX using a UNION function, but I'd recommend you do it in the Query Editor using the Append Queries function on the Home tab.