Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Microsoft is giving away 50,000 FREE Microsoft Certification exam vouchers. Get Fabric certified for FREE! Learn more

Reply
datadelta
Helper III
Helper III

Multiple data points to get a percentage of results

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?

1 REPLY 1
foodd
Super User
Super User

Please provide sample data (with sensitive information removed) that covers your issue or question completely, in a usable format (not as a screenshot).


https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...


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.

Helpful resources

Announcements
March PBI video - carousel

Power BI Monthly Update - March 2025

Check out the March 2025 Power BI update to learn about new features.

March2025 Carousel

Fabric Community Update - March 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors
Top Kudoed Authors