Forum Discussion

v_mark's avatar
v_mark
Helper V
5 years ago
Solved

Filter another table without relationship

Hello, been working on this type of model. 

 

employee table contains primarily: employee info dept, line of business etc. 

Problem table: has all the records reported as a problem which is all unique values 

Incident table:  May contains multiple Incident IDs for a certain Problem ID

 

my intent is to filter the problem table and employee table vise versa . Like, know how many PROBLEM IDs came from a certain location, dept, line of business ..

 

currently, there are no common fields between the two. However, there is a requesterID coming from the Incident table which I can probably use to merge into a reference Problem table and eventually another merge to employe table which end with duplicate values 

 

I was hoping to achieve that WITHOUT using the bi-directional filtering 

 

 

 

Need Help
Show and Tell
Tips and Tricks
  • littlemojopuppy's avatar
    littlemojopuppy
    5 years ago

    Hi v_mark you can use the TREATAS() function to simulate a relationship when no relationship exists.

     

    Your syntax would be something along the lines of

    CALCULATE(
	[Measure],
	TREATAS(Incident[RequesterID], Problem[Employee???})
)

     

    Hope this helps! ğŸ™‚

1 Reply

  • littlemojopuppy's avatar
    littlemojopuppy
    Community Champion
    5 years ago

    Hi v_mark you can use the TREATAS() function to simulate a relationship when no relationship exists.

     

    Your syntax would be something along the lines of

    CALCULATE(
	[Measure],
	TREATAS(Incident[RequesterID], Problem[Employee???})
)

     

    Hope this helps! ğŸ™‚