Forum Discussion

neil37's avatar
neil37
Advocate I
4 years ago
Solved

Calculated Column or Measure Question

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_TotalS...
  • Jihwan_Kim's avatar
    Jihwan_Kim
    4 years ago

    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 )
    )
Jihwan_Kim's avatar
Jihwan_Kim
Super User
4 years ago

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 )
)