topic Re: Calculated Column or Measure Question in DAX Commands and Tips

Calculated Column or Measure Question

neil37 — Wed, 26 Jan 2022 20:40:12 GMT

Hello,

I believe I am on the way to solving this but need that extra push from the great forum that this is.

If I have a dataset that resembles the below calculated table named "cTbl_TotalScoreCalculate"

Person	Totaled Score
Jim	123
Mike	234
Greg	345
Jessica	64

And I wanted to create either a measure or a calculated column that executed this function:

=(A1 - MIN(A:A)) / (MAX(A:A) - MIN(A:A))

What would I add in the syntax for what would be the bold red variable below?

I have the following syntax created but I am strugling with getting the syntax to calculate:

ScaledValue =
VAR MaxScore = MAX(cTbl_TotalScoreCalculate[Totaled Score])
VAR MinScore = MIN(cTbl_TotalScoreCalculate[Totaled Score])
Return
CALCULATE(((A1)-MinScore)/ (MaxScore - MinScore))

Caveats: The table where this calculated column is being generated is a calculated Table.

Thank you for your assistance!

Re: Calculated Column or Measure Question

VahidDM — Wed, 26 Jan 2022 22:12:47 GMT

Hi neil37

Try this to add a new column with DAX:

ScaledValue =
VAR MaxScore = calculate(MAX(cTbl_TotalScoreCalculate[Totaled Score]),all(cTbl_TotalScoreCalculate))
VAR MinScore = calculate(MIN(cTbl_TotalScoreCalculate[Totaled Score]),all(cTbl_TotalScoreCalculate))
Var _A1 = EARLIER ( cTbl_TotalScoreCalculate[Totaled Score] )

Return
(_A1-MinScore)/ (MaxScore - MinScore)

If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
LinkedIn: www.linkedin.com/in/vahid-dm/

Re: Calculated Column or Measure Question

Jihwan_Kim — Thu, 27 Jan 2022 04:43:25 GMT

Hi,

Please check the below picture and the attached pbix file.

It is for creating a calculated measure.

Expected result: =

VAR _min =

CALCULATE ( MIN ( cTbl_TotalScoreCalculate[Totaled Score] ), REMOVEFILTERS () )

VAR _max =

CALCULATE ( MAX ( cTbl_TotalScoreCalculate[Totaled Score] ), REMOVEFILTERS () )

RETURN

IF (

HASONEVALUE ( cTbl_TotalScoreCalculate[Person] ),

DIVIDE ( SUM ( cTbl_TotalScoreCalculate[Totaled Score] ) - _min, _max - _min )

)

Re: Calculated Column or Measure Question

neil37 — Thu, 27 Jan 2022 13:11:45 GMT

Thank you Jihwan_Kim & VahidDM !! Greatly appreciate your time and effort!!