Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Card with percentage

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?
Need Help
  • Phil_Seamark's avatar
    Phil_Seamark
    8 years ago

    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
					)
				)
Phil_Seamark's avatar
Phil_Seamark
Icon for Microsoft Employee rankMicrosoft Employee
8 years ago

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

Anonymous's avatar
Anonymous
Not applicable
8 years ago

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's avatar
    Phil_Seamark
    Icon for Microsoft Employee rankMicrosoft Employee
    8 years ago

    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's avatar
      Anonymous
      Not applicable
      8 years ago

      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.

       

       

      • parry2k's avatar
        parry2k
        Icon for Super User rankSuper User
        8 years ago

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