Forum Discussion
Helper IDisplaying progress as percentage for various datasets within one query
Make some measures, one just being Measure1 = countrows(yourtablename), another being True = calculate([measure1], Completed? = "TRUE"), and a final one that's just PercentageDone = [True]/[Measure1]
Solution SageMake some measures, one just being Measure1 = countrows(yourtablename), another being True = calculate([measure1], Completed? = "TRUE"), and a final one that's just PercentageDone = [True]/[Measure1]
Helper IThank you jthomson. While the measures work I have trouble displaying them. For example if I want to put the output on a simple column chart i get this:
MdxScript(Model) (4, 43) Calculation error in measure 'query1'[True]: DAX comparison operations do not support comparing values of type True/False with values of type Text. Consider using the VALUE or FORMAT function to convert one of the values.
I dragged MilestoneName into the Axis section, PercentageDone into the Value section.
- jthomson
I might have got the syntax wrong and/or misread how your data is stored, perhaps try using Completed? = TRUE() instead
- love
My query was reading the TRUE/FALSE as logical expression which I was not able to compare with the text (milestone column).
MilestoneName", type text}, {"Completed?", type logical}})I changed this to type text after which everything worked fine:
MilestoneName", type text}, {"Completed?", type text}})Thank you for your help jthomson.