cancel
Showing results for
Did you mean:

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Frequent Visitor

## Select a Table value based on a DAX function

Hey,

i have GDP data with colunms : Country, GDP, Year.

i used a Dax functions to calculate GDP Growth %, and ranked it In the Growth Rank Column.

Here's what i want to do :

I want to show the Year of highest Growth %  in a Card Visual (from the Table, it shows 1981), but can't seem to know how best to do it.

This is a table visual i created on power bi.

Table Visual

Apart from Year and GDP Column every other Column is calculated using DAX.

Here are the formulas :

LY GDP =
var _Ly = LASTNONBLANK('Countries GDP 1960-2020'[Year],1) - 1
var _1 = CALCULATE([GDPc]ALL('Countries GDP 1960-2020'[Year]),
'Countries GDP 1960-2020'[Year] _Ly )
return
_1

Growth % = DIVIDE((sum([GDP]) [LY GDP] ),[LY GDP])

Growth Rank = RANKX ( ALL ( 'Countries GDP 1960-2020'[Year] ),[Growth %] )

I have Gotten tremendious support from here, and i appreciate your responses.
1 ACCEPTED SOLUTION
Super User

Hi,

I am not sure how your data model looks like, but please try to put the below measure into a card visualization.

``````expected measure for card visual: =
SUMMARIZE (
FILTER (
ALL ( 'Countries GDP 1960-2020'[Year] ),
"@ranking", [Growth Rank]
),
[@ranking] = 1
),
'Countries GDP 1960-2020'[Year]
)
``````

If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.

Go to My LinkedIn Page

3 REPLIES 3
Super User

Hi,

I am not sure how your data model looks like, but please try to put the below measure into a card visualization.

``````expected measure for card visual: =
SUMMARIZE (
FILTER (
ALL ( 'Countries GDP 1960-2020'[Year] ),
"@ranking", [Growth Rank]
),
[@ranking] = 1
),
'Countries GDP 1960-2020'[Year]
)
``````

If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.

Go to My LinkedIn Page

Frequent Visitor

This is the Solution !!!

it worked.

Thanks for Helping Out.

Solution Specialist

LastYearGDP = lookupvalue('Countries GDP 1960-2020'[GDP], 'Countries GDP 1960-2020'[Year], 'Countries GDP 1960-2020'[Year] - 1, 'Countries GDP 1960-2020'[Country], 'Countries GDP 1960-2020'[Country])

BestGDP = maxx(values( 'Countries GDP 1960-2020'[Year]), calculate(DIVIDE(sum('Countries GDP 1960-2020'[GDP])-sum('Countries GDP 1960-2020'[LastYearGDP]),sum('Countries GDP 1960-2020'[LastYearGDP]))

Announcements

#### Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

#### Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

#### Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors