Forum Discussion
Create Seperate Visual based on different column lookup
It is also fine this way. It seems you have switched between the active and inactive relationships. You can do it either ways. But in order not to make mistakes I recommend you double check your relationships to confirm identidal to the sample file.
Nou_admin1
Great!
If you are satsfied with the result, I would kindly request you to mark my reply as accepted.
Thank you!
Hi Nou_admin1
Here is your file with the solution https://www.dropbox.com/t/eFiNfMRp7efEcjc3
First you need to have a date table. In the Master Table you need to have an FF MGR Emp. Code column. Then you can set your data model as follows
The rest is simple. Here are samples of the required measures
Call Avg =
IF (
HASONEVALUE ('Review Sheet'[Call Avg] ),
VALUES ('Review Sheet'[Call Avg] )
)MGR Call Avg =
CALCULATE (
[Call Avg],
USERELATIONSHIP ( 'Master Data'[FF MGR Emp. Code],'Review Sheet'[Emp Code] ),
CROSSFILTER ( 'Master Data'[Emp. Code], 'Review Sheet'[Emp Code], None )
)
Your report looks like this
Please let me know if this answers your query. Thank you!
Super, Thank you So Much tamerj1 - I got the Perfect Solution.
Let I apply the same in my Real Data and Generate the Report. If need any more help I will ping you.
Once Again Thanks to tamerj1 amitchandak
Sure anytime.