Forum Discussion
Resolver ICreate a Measure with an indirect relation
Hi I need help to create a measure to summarize the sales for an employee, but in my scenario, I've some cases where the employee has customers assigned but in some cases the employee has a sales area or a channel or a any geografic customer data.
My model has four tables.
One for customers with gographic info
One for sales by period and by customer
One fo employee
And one with the relation for an employee and customers or geografic.
My idea is create a table or matrix that shows the total sales for the associate related his relation with customers o terrotories.
Hi debiagui ,
Your statement seems a bit vague, whether the four tables provided are correct and whether there is a relationship between them. Can you give an example, such as how 57,418 corresponding to 1 of EmployeeId in the result is obtained. I will answer you as soon as possible.
Looking forward to your reply.
Best Regards,
Henry
5 Replies
- Greg_Deckler
Community Champion
debiagui Sorry, having trouble following, can you post sample data as text and expected output?
Not really enough information to go on, please first check if your issue is a common issue listed here: https://community.powerbi.com/t5/Community-Blog/Before-You-Post-Read-This/ba-p/1116882
Also, please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
The most important parts are:
1. Sample data as text, use the table tool in the editing bar
2. Expected output from sample data
3. Explanation in words of how to get from 1. to 2.- debiagui
Sorry about this, Greg_Deckler, I create a simple example in Excel here:
Hope this helps.-
- Greg_Deckler
Says deleted.
v-henryk-mstfCommunity Support
Hi debiagui ,
Your statement seems a bit vague, whether the four tables provided are correct and whether there is a relationship between them. Can you give an example, such as how 57,418 corresponding to 1 of EmployeeId in the result is obtained. I will answer you as soon as possible.
Looking forward to your reply.
Best Regards,
Henry
