Forum Discussion

AaronGlenn10's avatar
AaronGlenn10
Helper III
4 years ago
Solved

Ranking & Dynamic Title Help

I have a matrix with a list of restauraunt locations based on the City in the Selection Slicer.   Trying to accomplish two things: 1.) Only want to see Rankings when a restaurant is selected [in t...
Need Help
  • v-kkf-msft's avatar
    v-kkf-msft
    4 years ago

    Hi AaronGlenn10 ,

     

    Please try the following formula:

     

    Location Rank in State = 
CALCULATE (
    [Location Rank in City],
    REMOVEFILTERS ( TABC[City] ),
    KEEPFILTERS ( TABC[State] = MAX ( TABC[State] ) )
)

     

    If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.
    Best Regards,
    Winniz
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

AaronGlenn10's avatar
AaronGlenn10
Helper III
4 years ago

Thank you.

 

The rank for LOCATION within a CITY [e.g., #5 in the City of Dallas] works great, however, still can't resolve how to rank the LOCATION within the ENTIRE STATE of TEXAS.  Any guidance would be much appreciated.