Min / Max Age Measure per Ref Number

[KayCon]

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(TAFamilies[Age]),

    REMOVEFILTERS(TAFamilies),

    VALUES(TAFamilies[Ref.No]),

    Age

)

Return

Results

I've tried this but just gives me a max combined age of group I would need to able to filter of lead name or Ref.No so would need it to show 

1234

Joe Boggs

to show 35. I believe this would be better as a measure rather than a column. 

Thank you all.

[v-zhangti · Accepted solution]

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.

[lbendlin]

Please provide sample data (with sensitive information removed) that covers your issue or question completely, in a usable format (not as a screenshot). Leave out anything not related to the issue.
If you are unsure how to do that please refer to https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...
Please show the expected outcome based on the sample data you provided.

If you want to get answers faster please refer to https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...