Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

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 v...
Need Help
  • PaulDBrown's avatar
    PaulDBrown
    4 years ago

    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"

Anonymous's avatar
Anonymous
Not applicable
4 years ago

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] )
)
  • PaulDBrown's avatar
    PaulDBrown
    Community Champion
    4 years ago

    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