For more details regarding functions in this recipe, refer to the following links: RANKX: https://docs.microsoft.com/en-us/dax/rankx-function-dax FILTER: https://docs.microsoft.com/en-us/dax/filter-function-dax ALL: https://docs.microsoft.com/en-us/dax/all-function-dax