Division of column and measure

[tanujbhatia]

Hi,

Is there a possibility of division of column and measure?

I have a column 

Features in Backlog = CALCULATE(COUNTA(JIRA[issue]))

and a measure

 FeaturesDone = calculate(count(JIRA[IsComplete]), filter(ALLEXCEPT(JIRA, JIRA[clientrequesting]), JIRA[Status]= "Done" ))

Now i need percentage of featured done out of features in backlog. Using divide does not give correct results.

Or any other option?

Really appreciate any help on this.

Thanks,

[v-shex-msft]

HI @tanujbhatia ,

If you use measure to calculate with column, it is possible and can be effect by filter effect.
If you are try to created a dynamic calculated column based on filter/slicer, measure result will been fixed as static value when you used in calculated column.

Regards,

Xiaoxin Sheng

[tanujbhatia · Accepted solution]

Thanks i managed to make it work by changing both to measure.