AM 4 4 S 4 31,20 4 31 3. a new column: NetProductProfit in the 'DaxBook Sales' table. This column is the quantity of an ordered product multiplying the result of unit price minus the cost and discount. The first 10 records are shown (sort on NetProductProfit in descending order). 4. a new measure: [Multiltems Sales Amount] in the 'DaxBook Sales' table. This measure is the multiplication of Quantity and Unit Price, but only for those rows whose Quantity is greater than 1. Use a FILTER in the SUMX function to produce a that contains the rows whose Quantity is greater than 1. After the measure is created, go to the Report view, create a new Page and name it as Multiltem Sales. On this page, select Brand from 'DaxBook Product' table and Multiltem Sales Amount from 'DaxBook Sales' table, then select Matrix in the visualization pane to create a matrix table. AV W MI SU SLIP * 4 4 ALMA 24,30049 B B S S S www.w Brand $4 SLOW Proseware A. Dahim Fabri Adventure Work S Wide World Importers Soulf Viduu The Phone Company Nowind Tur d Tapi Toys 3.2.3 KUM KLIEN DACH M ALL 312 ALL WW 2 WW es Multitems Sales Amount $2,474,0022 $2,005,742.00 $1.079.423.04 $1.512.11.17 $1,151.456.73 $941 filh 3901,757.45 8033,333.40 $520,534 $457,020.12 $152.321.522 SM.141,5/an 2204 37:29. 172 RMN
