Get the max Value within a measure

[MarvinConceição]

Hey guys, can you help me on this one,

I got a measure [Sum LOS] that is the result of summing a logical colomn, and the total value of true values,

With this values I calculate the percentage of values in the measure [Q2 OS%].

They are ordered by the [Group], and the group has different [values]

I need to put on the right table the value of the groups, and it has to be the biggest [value] (12.43%), and not the average of both values (10.59%)

can you help me with this one,

Thanks

[parry2k]

@MarvinConceição try this measure

Max Average = 
MAXX ( VALUES ( Table[Group] ), [Average Measure] )

I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!

⚡Visit us at https://perytus.com, your one-stop shop for Power BI related projects/training/consultancy.⚡

[MarvinConceição]

Hey @parry2k , thanks for the fast reply

I don't know if i understood your answer, i tried following ut tip

Max Average =

MAXX ( VALUES ( 'Table'[Group] ), [Q2 OS%] )

But I get the

unexpected expression '[Q2 OS%]'

error

[parry2k]

@MarvinConceição do you have this [Q2 OS%] measure already, correct?

Make sure to change Table[Group] with your table name and group column name that you used in the matrix.

I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!

⚡Visit us at https://perytus.com, your one-stop shop for Power BI related projects/training/consultancy.⚡

[MarvinConceição]

hey @parry2k, yes I did change, and this [Q2 OS%] is a measure

here is the original line 

[parry2k]

@MarvinConceição I guess it is a language issue, can you replace , with ; 

Do you use comma or semi colon in your DAX expressions?

Also can you confirm you have Q2 OS measure

[MarvinConceição]

Oh! right, my bad, the comma was the issue, now it is running

But, what im trying to achieve is this

The second table need to show only the biggest percentage
sorry for all the trouble, I'm still new at this
thanks

[parry2k · Accepted solution]

@MarvinConceição try this

Max Average = 
MAXX ( SUMMARIZE ( Table, Table[Group], Table[Value],  "_Avg", [Your Measure] ),
[_Avg]
)

make sure to change the table and column name as per your model, change commas to semicolons.

I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!

⚡Visit us at https://perytus.com, your one-stop shop for Power BI related projects/training/consultancy.⚡

[MarvinConceição]

@parry2k I just tried it, there was no error, but Im still with the 10.59% instead of 12.43%

Sum Max Average =

MAXX ( SUMMARIZE ( 'Query2 (2)'; 'Query2 (2)'[line brand]; 'Query2 (2)'[line design]; "_Avg"; [Q2 OS%] );

[_Avg]

)

[parry2k]

@MarvinConceição I don't know which column you are using and how the measure is calculated. You have totally different columns in the original post and now you are using different columns, it is not very clear to me. On the original post, you have group and value columns in the table visual, and you have to use the same column in dax measure.

[MarvinConceição]

Thanks for the heads-up @parry2k , That happened cause my columns in the table have been renamed to what i need to show, so this would be this:

Sum Max Average =

MAXX ( SUMMARIZE ( Table; Table(Group); Table(Value); "_Avg"; [Q2 OS%] );

[_Avg]

)

Table = 'Query2 (2)'

Group = [line brand]

Value = [line design]

the measure is still [Q2 OS%]

Sum Max Average =

MAXX ( SUMMARIZE ( 'Query2 (2)'; 'Query2 (2)'[line brand]; 'Query2 (2)'[line design]; "_Avg"; [Q2 OS%] );

[_Avg]

)

[parry2k]

@MarvinConceição Seems like I'm missing something very obvious here and don't have full picture, The measure should work. Share pbix file with sample data, remove any sensitive information before sharing. 

[MarvinConceição]

Hey @parry2k , I was testing this again, it seems it just didn't update the measure, it is working as it should, thank you very much

[parry2k]

@MarvinConceição ahh, great. Glad to hear. uff!!

I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!

⚡Visit us at https://perytus.com, your one-stop shop for Power BI related projects/training/consultancy.⚡

[MarvinConceição]

Okay, let me try, I'll send you the link