How can I use Averagex with char not var?

[datadelta]

I'm trying to use this for items that have text not numbers.

Any thoughts would be appreciated!

AVERAGEX(

    KEEPFILTERS(VALUES('order_details'[productname]) AND 'order_details'[product_color]),

    CALCULATE(SUM('order_details'[order_amount]))

)

[ToddChitt]

Can't tell you how many times I have posted on this or other forums only to have the answer pop up or come to mind after I hit "Post".

[datadelta]

Thank you for sparking the thought!

[ToddChitt · Accepted solution]

AVERAGEX function (DAX) - DAX | Microsoft Learn

It is sort of assumed that when you are calculating an average, the column on which you make the caclulation is numeric in some way. 

What's the average of my colors? 

Doesn't really work, does it, becasue colors is not numeric.

Have you tried converting the number to something numeric? 

Are you getting an error message or pop-up on the formula? If so, can you paste in a screen shot?

Is [order_amount] the issue?

[datadelta]

I wish I had thought that through... having a numeric representative may work.  

The error is, :  The function SUM cannot work with values of type string

Thanks!