The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event: Join us in Stockholm, September 24-27, 2024.
Save €200 with code MSCUST on top of early bird pricing!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
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.
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the July 2024 Power BI update to learn about new features.
User | Count |
---|---|
115 | |
112 | |
69 | |
48 | |
43 |
User | Count |
---|---|
188 | |
87 | |
77 | |
74 | |
60 |