Forum Discussion
Create Seperate Visual based on different column lookup
Hi Team,
Please suggest me a idea how to arrive solution for my working.
I have a Data sheet which contains the data for Managers, Executive and Reps in a single sheet with continues column with there respective name and code and not differenciate the Designation in data sheet. But I have a Master Table with Designation wise reporting list. Based on this Master Data I have Filtered the data for Reps with the below Hierarchy order.
Manager - (slicer with Single Selection)
Executive (Slice with Multi selection)
based on this both slicer the Rep Value details will show in a visual.
Now I want to Show a Visual Screen only for Executive Data which is filtered in the Executive slicer screen. But I am getting the Sum of Reps data in that visual. How to avoid Reps Data in that visual and show only the Selected Executive data.
Note - In Data Sheet contains 8 nos of Column with Numeric Value.
Please suggest me a Idea of DAX Measurement for create .
Thanks
With Regards,
Ashok Babu
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!
9 Replies
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 measuresCall 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 thisPlease 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.
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.
Nou_admin1 ,
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.Hi Amit,
Thanks for your reply.
Here with I am attached the Download link of some Sample Data and Output Format. Please check and kindly suggest a suitable solution. Total 4 Sheet available 2 is Data sheet and 1 is master data based on master data the output needs to load as 1 sheet is for output sheet.
Download link
Thanks.
