New Column - How to subtract and divide by measures, getting Nan error

[ojt1]

Hi

I have created Median Messure and Standard Deviation Measure from columnA, and am now having difficulty creating a new column using these measures = 

New Column = ('table1'[ColumnA] - 'table1'[MedianMeasure]) / 'table1'[StandarDeviationMeasure]

My measures are both positive numbers, and all values in my column A are above 0, so nothing is diving by zero.

Any suggestions? 

I am working using the above calcuation based on the accepting solution to this thread:

https://community.fabric.microsoft.com/t5/Desktop/Can-PowerBi-give-me-Z-Scores/m-p/251709#M111820

[ojt1 · Accepted solution]

Incase anyone else has the same problem, through the link below, I found that you cannot devide a measure by a column, and instead need to create a measure of the column. After which, you can use the 3 measures to create a new Calculated Column:
https://forum.enterprisedna.co/t/z-scores-in-dax/4551

[Sahir_Maharaj]

Hello @ojt1,

Can you please try this:

Standardized ColumnA Measure = 
VAR MedianValue = [MedianMeasure]
VAR StandardDeviationValue = [StandardDeviationMeasure]
RETURN
DIVIDE(
    'table1'[ColumnA] - MedianValue,
    StandardDeviationValue
)

Hope this helps.

[ojt1]

Hi Sahir

Thank you for the reply. This calculation does not return anything in the column. I noticed you named it 'measure', which is slightly confusing for a column.