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!
Hi,
I am tried in my Actual Data the First Measure is not working properly. While apply the measure the Field Force Name is coming correct but the Data is showing the second measure value for all Field Force Name's as per the filtered conditions.
If I try same like as second measure for the first measure then the data is showing correct value. So I am used this way. Is there any wrong by doing this way?
Thanks
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.
Yes, you are Right. Now all Perfect. I did mistake in Relationship mapping and now corrected.
Thank you So much
Nou_admin1
Great!
If you are satsfied with the result, I would kindly request you to mark my reply as accepted.
Thank you!