Forum Discussion
Solved
Top N with multiple variables
I am trying to make a 100% stacked bar chart that gives me the percentage of revenue shared by the top 2 industries in a state. I don't want the overall top 2 by all states. For example, Georgia coul...
Sample data and sample DAX expression for you reference.
Column = RANKX(FILTER(Table2,Table2[Country]=EARLIER(Table2[Country])),Table2[Amount],,DESC)If this is not what you want, please provide us some sample data and your expected result, so that we can make further analysis.
Regards,
Charlie Liao
v-caliao-msft
Microsoft Employee
Microsoft Employee
Sample data and sample DAX expression for you reference.
Column = RANKX(FILTER(Table2,Table2[Country]=EARLIER(Table2[Country])),Table2[Amount],,DESC)
If this is not what you want, please provide us some sample data and your expected result, so that we can make further analysis.
Regards,
Charlie Liao