Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

October 28 & 29: Experts share their secrets on how to pass the Fabric Analytics Engineer certification exam—live. Learn more

Reply
Anonymous
Not applicable

TopN

Hi , please i need our help again.

I have 2 tables : 

casflows : Id , name ,[Nav]

[Nav] is a measure I created. 

Investee: id , legal name

I want to have the top 5 legal names according to the value of [Nav].

relation between them is cashlows(n) Investee(1).

I try with this measure but it don't work : 

SUMX ( TOPN ( 5, Investee, 'Investee'[LegalName], DESC ), [NAV ] )
 
Thanks in advance 
 

 


1 ACCEPTED SOLUTION

Did you try this?

"Try creating a table visual with legal name and [NAV]. Select the legal name field in the filter pane, choose TopN in the dropdown, type in 5 and add the [NAV] measure as the "by value" field"





Did I answer your question? Mark my post as a solution!
In doing so, you are also helping me. Thank you!

Proud to be a Super User!
Paul on Linkedin.






View solution in original post

6 REPLIES 6
Anonymous
Not applicable

Thanks for your answer but when i add in my matrix another measures some legal name are removed from my matrix . How resolve it Please ? 

kind 

Anonymous
Not applicable

this my nav measure : 

 

NAV Q = SUMX(CashFlows
, CashFlows[LPValue] * MAXX(
FILTER( ExchangeRates
, ExchangeRates[Date] = CashFlows[OperationDate]
&& ExchangeRates[SourceCurrencyCode] = CashFlows[Currency]
&& CashFlows[IsInvestorCurrency]=TRUE()
                 &&CashFlows[OperationDate] = SELECTEDVALUE(ReportingDate[ReportingDate])
)
, ExchangeRates[Rates] )
)

Ok. Try creating a table visual with legal name and [NAV]. Select the legal name field in the filter pane, choose TopN in the dropdown, type in 5 and add the [MAV] measure as the value





Did I answer your question? Mark my post as a solution!
In doing so, you are also helping me. Thank you!

Proud to be a Super User!
Paul on Linkedin.






PaulDBrown
Community Champion
Community Champion

What is the NAV measure?

can you share some dummy data or PBIX file?





Did I answer your question? Mark my post as a solution!
In doing so, you are also helping me. Thank you!

Proud to be a Super User!
Paul on Linkedin.






Anonymous
Not applicable

I tried with ADDcolumn, Summarize to create a virtual table before applying my topnN but I still have no solution, but thanks for your answer.

Did you try this?

"Try creating a table visual with legal name and [NAV]. Select the legal name field in the filter pane, choose TopN in the dropdown, type in 5 and add the [NAV] measure as the "by value" field"





Did I answer your question? Mark my post as a solution!
In doing so, you are also helping me. Thank you!

Proud to be a Super User!
Paul on Linkedin.






Helpful resources

Announcements
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

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

October NL Carousel

Fabric Community Update - October 2024

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