Card with percentage

[Anonymous]

Good afternoon,

I have a table with two columns, Year and percentage. Want to return the highest year's percentage on a card, any ideas?

[Phil_Seamark]

HI @Anonymous

There are a bunch of ways you can do this.

One quick thing to try might be to use the Top N filter on your visual.

Otherwise there will be ways to solve this using DAX or M

[Anonymous]

Hi @Phil_Seamark

Thanks for your response.

Could you give me the way to resolve with a dax measure. I need to use the result in another measure.

Remember, the table has two columns (year and percentage) and I want to get the percentage of the largest year.

[Phil_Seamark]

Do you just want the percentage value?  Or do you somehow need the year as well?

[Anonymous]

Only in percentage

Table
Year   Percentage
2017   10%
2016   13%

In that case the card will display 10%. This value will be used in other measures.

[Phil_Seamark]

HI @Anonymous

I'm confused.  Wouldn't this mean 13% is the highest percentage?

Or do you mean you have mulitple rows for each year with different percentages and  you want to display the highest percentage for each year?

[Anonymous]

Here is the table I'm using.

The result I need is the 13.55% percentage for the year 2017.

This percentage will always be the most recent year.

[Phil_Seamark · Accepted solution]

Aha!

I think this might be close.  Just change where I have Table2 to your tablename

Measure = 
VAR maxYear = MAX('Table2'[Ano])
RETURN CALCULATE(
				MAX('Table2'[Reajustes]),
				FILTER(
					'Table2',
					'Table2'[Ano] = maxYear
					)
				)

[Anonymous]

Thank you for your help. Worked perfectly.

[parry2k]

what i suggested should work, just change the aggregation to Max for percentage

[parry2k]

Drop percentage column on card and change aggregation to MAX.

Add a slicer for year to pick a year.