Maximum of Calculated Measurement to get the Text Value

[Surekha_PM]

Hello,

I have one column which is a calculated measurement and one column which comes from the table and has text value. I need to show the maximum of the measurement value and show in the card the text value. 

For example, if I add the measurement and text in one table, this is how it will look like below

Percentage (calculated)	Name (Included in Table)
19.37%	A
12.35%	B
6.09%	C
5.89%	D
5.74%	E

I need to show "A" data in card. And it should also change as per the filter. I used below function but it didn't work

VAR MaxValue = [MaxCalculatedMeasureValue]
RETURN
MAXX(
FILTER(
'YourTableName',
[CalculatedMeasure] = MaxValue
),
'YourTableName'[TextColumn]
)

Any suggestions please.

Thanks & Regards,
Surekha

[Surekha_PM · Accepted solution]

Hi @bhanu_gautam,

I am able to fix the issue now. Basically, I took a different approach, which included less efforts. Instead of createing another formula, I created a Multi-row Card and added the dimension and measurement in it. Now, for the measurement, I am filtering Top 1 and am able to see the Top Name in the card. I have removed the measurement value from the Multi-Row card and now able to get the result which was needed. 

This solution will help to those who are still struggling with this issue.

Regards,
Surekha

[bhanu_gautam]

@Surekha_PM , That's great

[Surekha_PM]

Hello,

Can anyone help me with this query?

Regards,

[bhanu_gautam]

@Surekha_PM , Update your measure as

MaxTextValue =
VAR MaxValue = CALCULATE(MAX('YourTableName'[CalculatedMeasure]))
RETURN
CALCULATE(
MAXX(
FILTER(
'YourTableName',
'YourTableName'[CalculatedMeasure] = MaxValue
),
'YourTableName'[TextColumn]
)
)

[Surekha_PM]

Hi @bhanu_gautam,

Thank you for your reply. 

I am getting this error everytime:

Column 'CalculatedMeasure' in table YourTableName' cannot be found or may not be used in this expression.

Any idea what is this?

Regards,
Surekha

[bhanu_gautam]

Replace it with column 

VAR MaxValue = [MaxCalculatedMeasureValue]

RETURN which you have used in your measure

[Surekha_PM]

Hi @bhanu_gautam,

Sorry, I didn't get your answer. Could you please elaborate a bit?

Regards,
Surekha

[bhanu_gautam]

@Surekha_PM , Can you share sample data or PBIX file

[Surekha_PM]

Hi ,

I won't be able to share the PBIX file. But here is the formula I am using to get the calculated meeasurement sharedd above.

1st Measurment= CALCULATE(COUNT(Table[Name]),Table[Win]>0,ALL(Table[Name]))

CalculateMeasurement (added in the above table)=

var X= CALCULATE(COUNT(Table[Name]),Table[Win]>0)

Var A= DIVIDE(x,[1st Measurment])

Return A 

Once I run this formula I am getting below table.

Percentage (calculated)	Name (Included in Table)
19.37%	A
12.35%	B
6.09%	C
5.89%	D
5.74%	E

The Name column has been used to generate the calculated measurement. And the same we are trying to show in MAX function. Is it because of that?

Regards,
Surekha