Fixing DAX issues with wrapper functions

Sometimes in DAX, we cannot choose measures, or columns when we might expect to, e.g. an IF formula cannot take a column, or other times DAX acts in an unexpected way, like CALCULATE filters are sometimes not allowed or giving repeated numbers. I will show in this video how to:
- Use a column when a measure is expected with SELECTEDVALUE
- Use a column when a table is expected using VALUES, eg to use in SUMX
- Fix CALCULATE issues not allowed with FILTER, or KEEPFILTERS to get filters to look as expected
- GET RANKX to work using ALL or ALLSELECTECTED and more

Example files can be found here: www.xlconsulting-asia.com/youtube-files

DAX for the Excel user, if you're not familiar with DAX or CALCULATE here: https://youtu.be/hMdJjsnzTAI

00:00 - Introduction
00:58 - SELECTEDVALUE
03:48 - KEEPFILTERS for CALCULATE
05:46 - FILTER in CALCULATE
09:19 - SUMX: Fix with VALUES
11:05 - Other errors
11:54 - RANKSX: ALL, ALLSELECTED

Видео Fixing DAX issues with wrapper functions канала David Benaim