Get row value from specific column

[darkhorse12]

Hey, I am new to Power BI, 

I have 2 columns,

and I want to get comments when I am on that report page.

Report Page	Comment
Cycle time	Note: calculated cycle time
Delivery time	Note: delivered
load time	Note: 2.5 hours
detailed cycle time	Note: calculated detailed cycle time

I have created measure:

Note for Cycle Time =

var result = FILTER(ALLSELECTED(Notes[Comment]),

RANKX(ALLSELECTED(Notes[Comment]),Notes[Comment],,DESC)=3)

RETURN result

but not getting perfect values.

Does anyone suggest me?

thanks.

[amitchandak]

@darkhorse12 , Try to use TOPN

CALCULATE([Comments],TOPN(10,allselected(Notes[Comment]),[Comments] ,DESC),VALUES(Notes[Comment]))

or first create a rank Assuming Comment is measure, count of comment or something like that

Rank =RANKX(ALLSELECTED(Notes[Comment]),Notes[Comment],,DESC)

Then a measure

sumx(filter(values(Notes[Comment]), [Rank] =3) ,[Comment] )

[JirkaZ]

What is the expected outcome? I kind of don't understand why you're using ranking in your DAX. 

[darkhorse12]

The expected outcome is in the smart narrative is to choose the measure

like:- cycle time then it should show the result of that row's comment that (Note: Calculated cycle time) 

[Anonymous · Accepted solution]

HI @darkhorse12,

I'm still not so clear about your requirement, can you please explain them with some more detailed information with expected results?

How to Get Your Question Answered Quickly 

Did you mean to get the specific index of comments based on the report page groups? If that is the case, you can take a look t the following link to add the group index at the query editor side. Then you can simply write the DAX formula to lookup value based on the current gorup value and index.

Create Row Number for Each Group in Power BI using Power Query - RADACAD

LOOKUPVALUE function (DAX) - DAX | Microsoft Docs

Regards,

Xiaoxin Sheng