Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

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 e...
Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago

    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
     
     
Anonymous's avatar
Anonymous
Not applicable
6 years ago

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's avatar
Gordonlilj
Solution Sage
6 years ago

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%