Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hey community, could really use your help with this.
My database has rows of transactions. I am trying to rank them based on their average margin in a table visual, by state.
Because I am pulling from different data sources for the same visual, I created a State dimension table to connect my transactions with another fact table (that gives me other data I need by state). I have been unsuccessful using the State field from both my State table and my transaction table.
The following equations have not worked:
Hi, @rleseberg
Can you provide simple EXCEL data or simple PBIX files for testing? What kind of results do you expect? Is it possible to provide pictures for reference. Looking forward to more details you can provide, thank you.
Best Regards,
Community Support Team _Charlotte
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi,
Does this work?
Rank Margin % = RANKX(ALLSELECTED(Table[State]),[Margin % Measure])
If not, then share the link from where i can download your PBI file.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
100 | |
80 | |
64 | |
57 |
User | Count |
---|---|
145 | |
111 | |
92 | |
84 | |
66 |