Forum Discussion

itchyeyeballs's avatar
itchyeyeballs
Icon for Impactful Individual rankImpactful Individual
6 years ago
Solved

Measure for max by group

Hi All,   I'm looking to turn this calculated column into a measure: XtPoints_Scaled = VAR Xi = Core_Data_All[XTPOINTS] VAR MnX = CALCULATE(MIN(Core_Data_All[XTPOINTS]),FILTER(Core_Data_All,Core_...
Need Help
  • Icey's avatar
    Icey
    6 years ago

    Hi itchyeyeballs ,

    Maybe you could try this:

    Measure =
DIVIDE (
    MAX ( Core_Data_All[XTPOINTS] )
        - CALCULATE (
            MIN ( Core_Data_All[XTPOINTS] ),
            ALLEXCEPT ( Core_Data_All, Core_Data_All[Year] )
        ),
    CALCULATE (
        MAX ( Core_Data_All[XTPOINTS] ),
        ALLEXCEPT ( Core_Data_All, Core_Data_All[Year] )
    )
        - CALCULATE (
            MIN ( Core_Data_All[XTPOINTS] ),
            ALLEXCEPT ( Core_Data_All, Core_Data_All[Year] )
        )
)

    Best Regards,
    Icey

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Icey's avatar
Icey
Icon for Community Support rankCommunity Support
6 years ago

Hi itchyeyeballs ,

Maybe you could try this:

Measure =
DIVIDE (
    MAX ( Core_Data_All[XTPOINTS] )
        - CALCULATE (
            MIN ( Core_Data_All[XTPOINTS] ),
            ALLEXCEPT ( Core_Data_All, Core_Data_All[Year] )
        ),
    CALCULATE (
        MAX ( Core_Data_All[XTPOINTS] ),
        ALLEXCEPT ( Core_Data_All, Core_Data_All[Year] )
    )
        - CALCULATE (
            MIN ( Core_Data_All[XTPOINTS] ),
            ALLEXCEPT ( Core_Data_All, Core_Data_All[Year] )
        )
)

Best Regards,
Icey

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.