Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
I'm trying to build a report that shows a percentage of times a sale was made by supplier based on multiple items. So, if the buyer needs a hard hat, what percentage of sales went to what supplier. If they needed a hard hat and a chainsaw, what's the percentage of success / sales that went to what supplier?
Items:
Hard Hat
Ladder
Hammer
Chainsaw
Suppliers:
Bob's Surplus Tools
Tractor and Tool Supplies
Beyond The Build Supply Store
Example:
Hard hat, Hammer - 33% Successful sale at Tractor and Tool Supplies, 20% successful sale at Bob's, 25% successful sale at Beyond.
Chainsaw - 100% success at Tractor, Bob's and Beyond.
The percetnages I'm getting are a percetnage of total not broken out by using multiple delta items. Therfore I'm not able to show where your best probability is for a sale of one or multiple items by supplier.
Any thoughts?
Please provide sample data (with sensitive information removed) that covers your issue or question completely, in a usable format (not as a screenshot).
Please show the expected outcome based on the sample data you provided.
https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...
This allows members of the Forum to assess the state of the model, report layer, relationships, and any DAX applied.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
146 | |
85 | |
66 | |
52 | |
47 |
User | Count |
---|---|
215 | |
90 | |
83 | |
66 | |
58 |