Occasional Visitor
Posts: 1
Registered: ‎04-05-2017

Lab 2 Exercise 4


after typing in the following measure:


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


I'm getting this error:


The syntax for '.0' is incorrect. (DAX(IF([Total VanArsdel Sales]=0.0,DIVIDE([Total VanArsdel Sales],[Total Sales].0))))


I've looked at the hint at the bottom of the page, and adjusted it accordingly but still get the same error


Here's the hint:


  • % Units Market Share: % Units Market Share = IF([Total VanArsdel Units]=0,0,DIVIDE([Total VanArsdel Units],[Total Units],0))

Any help?

Posts: 138
Registered: ‎03-10-2016

Re: Lab 2 Exercise 4

The hint is right, You can refer the formula below:

Measure 2 = IF([Total VanArsdel Sales]=0,0, DIVIDE([Total VanArsdel Sales],[Total Sales],0))