Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
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 :
Solved! Go to 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"
Proud to be a Super User!
Paul on Linkedin.
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
this my nav measure :
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
Proud to be a Super User!
Paul on Linkedin.
What is the NAV measure?
can you share some dummy data or PBIX file?
Proud to be a Super User!
Paul on Linkedin.
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"
Proud to be a Super User!
Paul on Linkedin.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
If you love stickers, then you will definitely want to check out our Community Sticker Challenge!
User | Count |
---|---|
137 | |
70 | |
64 | |
52 | |
50 |
User | Count |
---|---|
208 | |
91 | |
62 | |
59 | |
56 |