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.
Hi everybody,
I need to do a report on our IT service activity. I have 2 tables, SD_REQUEST is a list of tickets and SD_CATALOG_PATH is a category list for those tickets. They are linked by SD_CATALOG_ID key.
I need to create a pie chart of the top 5 categories.
I tried the following mesure
TOP = RANKX('50005 SD_CATALOG_PATH';SUM('50005 SD_REQUEST'[RFC_NUMBER]);;DESC;Dense)
but it returns the error "The function SUM takes an argument that evaluates to numbers or dates and cannot work with values of type String"
Thanks helping
Solved! Go to Solution.
My request is now resolved thanks to the new feature.
My request is now resolved thanks to the new feature.
hi. '50005 SD_REQUEST'[RFC_NUMBER] is a String?.
Check and change if is necessary.
Hello,
Yes RFC_NUMBER is a string. It can be "i170103_003" or "r160308_152".
And if I try with the key REQUEST_ID (which is a number), all the categories are ranked #1.
(note RFC_NUMBER and REQUEST_ID are unique)
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 |
---|---|
107 | |
97 | |
75 | |
63 | |
53 |
User | Count |
---|---|
144 | |
103 | |
98 | |
85 | |
64 |