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

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.

Reply
Anonymous
Not applicable

How to create a % from a single column value

Hi All,

 

I kindly need your help to solve my problem. Currently I have data like below table:

List of Data.PNG

 

and i would like to create a report such as below template:

 

Report Template.PNG

 

The problem that I have is related to contribution %. Actually it is a simple calculation from total gross sales. For "SKU Contribution", the calculation is gross sales per SKU/gross sales product category which means the when the % per SKU summed up, the total % for every product category is 100%. Meanwhile for Channel Contribution calculation is gross sales contribution by channel by sku or by product category/total gross sales.

 

Can  anyone help me explaining how to create such report template in power BI? If i should use custom column, kindly explain how to create the code.

 

I really appreciate all of your comments.

 

Thank you

 

1 REPLY 1
HotChilli
Super User
Super User

Create 2 measures

Gross Sales Amount = SUM(Table1[Gross Sales]) 

Contribution by SKU = [Gross Sales Amount] / CALCULATE(SUM(Table1[Gross Sales]), ALL(Table1[Type]))

Pull 'Gross Sales Amount' into the Values well of a matrix.

Pull 'Contribution by SKU' twice into the Values well of the matrix. For the second one, right-click and choose 'Show value as '->Percent of Row Total.   Then rename the second one 'Contribution by Channel'

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

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

Top Solution Authors