Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Dear All
I'attached my model.
the other tables are not relevant to my concern
I would lie to create a measure that allow me to know the amount of won opportunites. Sales stage (field in Booking profile" table tells me which opportunites are won and the amount by Business units is present in the "Opportunities with BLI" I need this measure to be fltered through slicers by Business unit, By sales team member, by date
I am using power pivot not BI otherwise it will simple by using the birectional filtering
please support
Regards,
Imbrg
Solved! Go to Solution.
Hi,
You may download my solution workbook from here.
Hope this helps.
@Anonymous,
In Power BI Desktop, you are able to establish birectional relationship between tables.
Could you please share sample data of your tables and post expected result based on sample data here? You can follow the guide in this blog to provide sample data.
Regards,
Lydia
Hi AIB
thank you for you quick answer.
I still do not understant how can I solve this proble as I am beginner in dax.
hat I would like to achieve is a measure that calculates won Opportunities and can slice that bases on a particular team member (from Opportunites with STM)
regards
Hi @Anonymous
Please provide details for one of the measures that you need: fields involved and what tables they are in, plus relationships between those tables. We'll take it from there.
If you can share the excel file you're working with (or a sample of it) it'd make things easier
Hello,
Please find below the link for the excel file I am workng on
I've created a measure that calculates the won opportunities based on the sales stage. It sums the amounts from the booking details table
I inserted two slicers : Name of the sales team members and Business units.
I filters when using the slicer Business unit but not the name of the sales team member.
Please advide
thank you for your help
regards,
Hi,
The Pivot Table does not respond to a selection in the Name slicer simply because there is no User ID column in the Booking Table. There should be a user ID column there with a relationship to the Users Table.
Hi Ashish
Thank you for your quick answer
I cannot have user id in the table booking as for a particular booking I can have many sales team members working on it.
and this is my problem
How can I know for a particular team member which opportunites were won and he was involved.
thanks
That's a crucial missing piece of information. We musy have that to all UserID wise slicing.
I did not understand you answer. we cannot have this kind of filter?
No, you cannot. Think about it - you are trying to filter your data by a column which bears no relationship (direct or indirect) with the Billing Table.
There is a relationship between the booking table (one side) and the STM which is the sales teams mumber (many sides)
Hi,
I think i can solve this. I need the 3 Excel files - Booking, STM and Booking details. Share just one Excel file with these 3 tables.
thanks Ashish for your support
here is the link
Hi,
You may download my solution workbook from here.
Hope this helps.
Hi Ashish that's working fine. The idea was to merge the two tables STM and Booking details right?
thanks
Ashish,
The total pipeline is not good as there is duplicates
I write the followinf measure but it's not working
Pipeline:=SUMX(FILTER('Booking details and STM', DISTINCT('Booking details and STM'[Unique Opportunity ID])),[Amount])
can you please support
thanks
Hi,
Right click on Booking details and STM Table and click on Edit. Select all columns, right click and Remove Duplicates. Click on Close and Load. Do you now get the correct results?
Thanks it's working
You are welcome.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
115 | |
100 | |
88 | |
68 | |
61 |
User | Count |
---|---|
152 | |
120 | |
102 | |
87 | |
68 |