Forum Discussion
Measure using DIVIDE " Operator or expression '()' is not supported in this context error
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
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:
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%
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%