Forum Discussion
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
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
4 Replies
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"))
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]))*100If 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%
