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 could have industry x and y as there top 2 while Florida could have industry x and z. I saw that you could make a RANKX off of another post, but PowerBi kept giving me errors. The code is as follows: RANKX(ALL(Sheet1[Industry]),CALCULATE(SUM(Sheet1[Revenue]),ALLEXCEPT(Sheet1,Sheet1[Industry],Sheet1[State])),DESC,Dense). Does anyone know if there is a more efficient way or if my code is just wrong? Thanks.