Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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
Solved! Go to Solution.
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]
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]
Thank 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.
I might have got the syntax wrong and/or misread how your data is stored, perhaps try using Completed? = TRUE() instead
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.
User | Count |
---|---|
124 | |
108 | |
99 | |
65 | |
62 |
User | Count |
---|---|
137 | |
116 | |
102 | |
71 | |
61 |