Forum Discussion
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(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.
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&"/"&_MAXIs 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.
2 Replies
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/1447523Hi, 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&"/"&_MAXIs 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.
