Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I'm using a fuel gauge to show completion of chats vs total initiated calculated using measures.
I want to add a dynamic target of 20% but can't figure out how to do it, I tried writing a measure:
MdxScript(Model) (24, 36) Calculation error in measure 'Measures table'[20COM]: The function SUM cannot work with values of type String.
How can I create a dynamic target of 20% of total completed that I can use for my fuel gauage target value?
Hey @HarperCash
Please check the data type of completed column in 'KPI' table. It should be decimal or whole number to use it with SUM().
If this helps you then please mark my solution as accepted so that others can find it easily while facing similar issue. Thank You!
Hey,
Thanks so much! I created a new column with a numnerical value then created the measure but when I add that to my fule gauage nothing is showing? I get no error but it isn't adding a target of 20% it just stays the same
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
102 | |
101 | |
78 | |
70 | |
63 |
User | Count |
---|---|
141 | |
106 | |
101 | |
85 | |
72 |