A anishms Member Jan 17, 2020 #1 To show the discount percentage against gross in a table by adding a new measure. Following is the formula what I wrote in the new measure and put that measure in the value field Discount% = CALCULATE(SUM(Table1[Discount (AED)])/SUM(Table1[Gross (AED)])*100) Last edited: Jan 17, 2020
To show the discount percentage against gross in a table by adding a new measure. Following is the formula what I wrote in the new measure and put that measure in the value field Discount% = CALCULATE(SUM(Table1[Discount (AED)])/SUM(Table1[Gross (AED)])*100)
A anishms Member Jan 18, 2020 #3 Chihiro said: Is this question or statement? Click to expand... It was a question initially. Then I found the solution after posting. As I was not able to delete the post, I changed it to a statement.
Chihiro said: Is this question or statement? Click to expand... It was a question initially. Then I found the solution after posting. As I was not able to delete the post, I changed it to a statement.
