Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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!
Solved! Go to 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.
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.
Thank you so much! It worked perfectly.
User | Count |
---|---|
141 | |
113 | |
104 | |
77 | |
64 |
User | Count |
---|---|
135 | |
123 | |
101 | |
71 | |
61 |