Forum Discussion
Solved
Feature Scaling using Dax
Hi, I wonder if any one can help. I pretty new to powerBI and Dax and I am struggling to normalsie a variable using the Feature Scaling Method. I am trying the below but it is bring up the fo...
HI Polly,
Based on your formula. I think you want to use current value to deal with max/min value from current table, right?
If this is a case, you should use calculate or minx/maxx function to apply the filter for this formula.
Result =
DIVIDE (
SUM ( 'Table'[Amount] ) - MINX ( ALL ( 'Table' ), 'Table'[Amount] ),
MAXX ( ALL ( 'Table' ), 'Table'[Amount] )
- MINX ( ALL ( 'Table' ), 'Table'[Amount] )
)Regards,
Xiaoxin Sheng
HI Polly,
Based on your formula. I think you want to use current value to deal with max/min value from current table, right?
If this is a case, you should use calculate or minx/maxx function to apply the filter for this formula.
Result =
DIVIDE (
SUM ( 'Table'[Amount] ) - MINX ( ALL ( 'Table' ), 'Table'[Amount] ),
MAXX ( ALL ( 'Table' ), 'Table'[Amount] )
- MINX ( ALL ( 'Table' ), 'Table'[Amount] )
)
Regards,
Xiaoxin Sheng
Thanks!