Reply
Frequent Visitor
Posts: 4
Registered: ‎10-13-2018

Re: Power BI Desktop Modelling > Lab 2 > Exercise 4: Market Share

Total VanArsdel Sales = CALCULATE([Total Sales],Manufacturers[Manufacturer]="VanArsdel")

% Sales Market Share = IF([Total VanArsdel Sales]=0,0,DIVIDE([Total VanArsdel Sales],[Total Sales],0))

Total VanArsdel Sales figure is $2,276,898,965.01

% Sales Market Share figure is 44.40%