• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User


  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Power bi - Calculate discount % in a table by new measure


New Member
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: