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 un...
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! 🙂

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! 🙂