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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Vish24
Helper II
Helper II

Need to show percentage in a table display as per defined column

Hello, I have a data table (Named - Goal) with 10 names and their goals and in separate data table(Named-AllSales) I have all sales done by those 10 people over the years.  I am making a table display in my report where I want to show the column with % of sales achcieved as per the goals. Like: 

 

Name    Goal    Total Sales   %Sales Achieved

A           100           10                   10%

B             80          40                       50%

C            120         90                      75%

 

I have made the name,goal,and total sales but I am not getting how to do the %.

 

Please suggest!

Thank you!

 

 

1 ACCEPTED SOLUTION

Hi @Vish24 ,

 

create a Measure and set the format to percentage.

%Sales Achieved = DIVIDE(SUM(Table[Total Sales]),SUM(Table[Goal]))

 

Regards,

Marcus

Dortmund - Germany
If I answered your question, please mark my post as solution, this will also help others.
Please give Kudos for support. 

Did I answer your question?
Please mark my post as solution, this will also help others.
Please give Kudos for support.

Marcus Wegener works as Full Stack Power BI Engineer at BI or DIE.
His mission is clear: "Get the most out of data, with Power BI."
twitter - LinkedIn - YouTube - website - podcast


View solution in original post

2 REPLIES 2

Hi @Vish24 ,

 

create a Measure and set the format to percentage.

%Sales Achieved = DIVIDE(SUM(Table[Total Sales]),SUM(Table[Goal]))

 

Regards,

Marcus

Dortmund - Germany
If I answered your question, please mark my post as solution, this will also help others.
Please give Kudos for support. 

Did I answer your question?
Please mark my post as solution, this will also help others.
Please give Kudos for support.

Marcus Wegener works as Full Stack Power BI Engineer at BI or DIE.
His mission is clear: "Get the most out of data, with Power BI."
twitter - LinkedIn - YouTube - website - podcast


Thank you so much! It worked perfectly.

 

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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