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

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'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.