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

 


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"

6 Replies

  • PaulDBrown's avatar
    PaulDBrown
    Community Champion
    4 years ago

    What is the NAV measure?

    can you share some dummy data or PBIX file?

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      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.

      • PaulDBrown's avatar
        PaulDBrown
        Community Champion
        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

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    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