Calculate Gross Sales with columns have value "percentage"

[islam_zaki]

Hi All

I have a transaction table, contact many columns include gross sales "Vales" and Discount "Value" is the discount percentage. 

Example: 

Gross Sales = 100.00 

Discount= 5.00 "This value have to baclulated as percentage" 

The result = 95.00

Thanks in advance.

[islam_zaki]

Hi All 

Thanks for supporting all, both (Measure and Column) of this giving me the total amount, My DB each item has Gross sales value and I need to get each item value. 

Here is the total Gross sales for Store#10 from starting of the year the measure or column not filtring with date or any there field. 

FYI

Table has : 

Area

Store#

SalesDate

cashier#

transaction#

barcode

Thanks again for all of the advising and supporting, which to get what I am looking for.

Regards

[_adamdosso]

Create a new measure RESULT

RESULT = SUM('Table'[Gross Sales]) -  SUMX('Table','Table'[Gross Sales] * ('Table'[Discount]/100))

[amitchandak]

@islam_zaki ,

New column = ((100 -[Discount]) *[Gross Sales])/100