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

[Anonymous]

%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

[Gordonlilj]

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 · Accepted solution]

hi @Gordonlilj 

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

[Gordonlilj]

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%

[Gordonlilj]

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%