Forum Discussion

KayCon's avatar
KayCon
Frequent Visitor
2 years ago
Solved

Min / Max Age Measure per Ref Number

Hi All    Just wanted some advice, I need to work out the MIN/MAX age for each party group.   ZMaxAgeOfTRef = Var Age = ALLSELECTED(TAFamilies[Age]) VAR Results = CALCULATE(    MAX(TAFamili...
  • v-zhangti's avatar
    v-zhangti
    2 years ago

    Hi, KayCon 

     

    You can try the following methods.

    Measure = 
Var _MIN=CALCULATE(MIN('Table'[Age]),ALLEXCEPT('Table','Table'[Ref No.]))
Var _MAX=CALCULATE(MAX('Table'[Age]),ALLEXCEPT('Table','Table'[Ref No.]))
Return
_MIN&"/"&_MAX

    Is this the result you expect?

     

    Best Regards,

    Community Support Team _Charlotte

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

     

v-zhangti's avatar
v-zhangti
Icon for Community Support rankCommunity Support
2 years ago

Hi, KayCon 

 

You can try the following methods.

Measure = 
Var _MIN=CALCULATE(MIN('Table'[Age]),ALLEXCEPT('Table','Table'[Ref No.]))
Var _MAX=CALCULATE(MAX('Table'[Age]),ALLEXCEPT('Table','Table'[Ref No.]))
Return
_MIN&"/"&_MAX

Is this the result you expect?

 

Best Regards,

Community Support Team _Charlotte

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