topic Re: Min / Max Age Measure per Ref Number in DAX Commands and Tips

Min / Max Age Measure per Ref Number

KayCon — Thu, 19 Oct 2023 20:32:24 GMT

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.

Re: Min / Max Age Measure per Ref Number

lbendlin — Sun, 22 Oct 2023 00:13:54 GMT

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-Forum/ba-p/963216
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/1447523

Re: Min / Max Age Measure per Ref Number

v-zhangti — Mon, 23 Oct 2023 11:56:03 GMT

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.