Forum Discussion
String Value in Calculating Measures
Hey, I'm trying to calculate the sum of sales by using the DAX measure function. However, when I try to plot this measure to a visual like a bar chart, it gives an error and says this sum function ca...
You can use MAX function. It will do like this:
Category_Measure = MAX(TableName[Category])
It is not the best solution, but for some situations it is possible to do
As a result you will get measure with categories as a strings. It should be the answer to your question