cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
houston39 Frequent Visitor
Frequent Visitor

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%