For more details about this recipe, please refer to the following links:
- FILTER: https://docs.microsoft.com/en-us/dax/filter-function-dax
- SWITCH: https://docs.microsoft.com/en-us/dax/switch-function-dax
- SUM: https://docs.microsoft.com/en-us/dax/sum-function-dax
- DIVIDE: https://docs.microsoft.com/en-us/dax/divide-function-dax
- COUNTROWS: https://docs.microsoft.com/en-us/dax/countrows-function-dax
- HASONEVALUE: https://docs.microsoft.com/en-us/dax/hasonevalue-function-dax
- IF: https://docs.microsoft.com/en-us/dax/if-function-dax
- BLANK: https://docs.microsoft.com/en-us/dax/blank-function-dax
- ISBLANK: https://docs.microsoft.com/en-us/dax/isblank-function-dax
- SUMX: https://docs.microsoft.com/en-us/dax/sumx-function-dax
- MAX: https://docs.microsoft.com/en-us/dax/max-function-dax
- FILTER: https://docs.microsoft.com/en-us/dax/filter-function-dax
- SUMMARIZE: https://docs.microsoft.com/en-us/dax/summarize-function-dax