Forum Discussion
Solved
Calculate Ratio in DAX ( Normalization)
I want to calculate ratio ( for normalization) and i get error NaN how can i solve it? it must be divide (CASH PAYMENT - Min(CASH PAYMENT), Max(CASH PAYMENT) - Min(CASH PAYMENT)) this is my measur...
I think this has already been done, anyways
Ratio =
var minPay = CALCULATE(MIN(bb[CASH PREPEYMENT]); ALL(bb))
var maxPay = CALCULATE(MAX(bb[CASH PREPEYMENT]); ALL(bb))
var Val = MAX(bb[CASH PREPEYMENT])
return
DIVIDE(Val - minPay; maxPay - minPay; 0)should give you a number between 0-1. If needed also you can hide where Val is blank.
I think this has already been done, anyways
Ratio =
var minPay = CALCULATE(MIN(bb[CASH PREPEYMENT]); ALL(bb))
var maxPay = CALCULATE(MAX(bb[CASH PREPEYMENT]); ALL(bb))
var Val = MAX(bb[CASH PREPEYMENT])
return
DIVIDE(Val - minPay; maxPay - minPay; 0)
should give you a number between 0-1. If needed also you can hide where Val is blank.