cancel
Showing results for
Did you mean: Anonymous
Not applicable

## Measure using DIVIDE " Operator or expression '()' is not supported in this context error

%Open = DIVIDE((COUNT('Report'[SEQ]);CALCULATE(COUNT('Report'[SEQ]);FILTER('Report';'Report'[actual] = "Open")))

Operator or expression '()' is not supported in this context error

Get this error in this measure. What im trying to do is get the % of seq that have status open relative to the total so if 300 of the 3000 have open it should give me 10% back

1 ACCEPTED SOLUTION Anonymous
Not applicable

Thank you for oyur quick response i managed to solve it with:

%Open = DIVIDE(CALCULATE(COUNT('Report'[SEQ]);FILTER('Report';'Report'[actual] = "Open"));COUNT('Report'[SEQ]))*100

4 REPLIES 4  Solution Sage

Hi,

It looks like you have one to many brackets so try removing them like i have done below

DIVIDE(COUNT('Report'[SEQ]);CALCULATE(COUNT('Report'[SEQ]);FILTER('Report';'Report'[actual] = "Open")) Anonymous
Not applicable

Thank you for oyur quick response i managed to solve it with:

%Open = DIVIDE(CALCULATE(COUNT('Report'[SEQ]);FILTER('Report';'Report'[actual] = "Open"));COUNT('Report'[SEQ]))*100  Solution Sage

If i understand you correctly you want to show the measure as percentage then you could remove the *100 and go into the modeling tab and click on the percentage symbol. It will convert numbers such as 0.89 to 89%   Solution Sage

If i understand you correctly you want to show the measure as percentage then you could remove the *100 and go into the modeling tab and click on the percentage symbol. It will convert numbers such as 0.89 to 89%    