Forum Discussion
Helper IDisplaying progress as percentage for various datasets within one query
Hello.
I face the following challenge:
I would like to visualize progress in % per milestone. So, for example, I'd like to visualize 100% for Milestone1, 60% for MS2 and 20% for MS3.
I am new to the community and I am finding lots of help here which I very much appreciate. I hope to find a simple sollution for this.
Thank you,
-l
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]
4 Replies
jthomsonSolution Sage
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]
loveThank 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