Below are some of the benefits:
* By declaring and evaluating a variable, the variable can be reused multiple times in a DAX expression, thus avoiding additional queries of the source database.
* Variables can make DAX expressions more intuitive/logical to interpret.
* Variables are only scoped to their measure or query, they cannot be shared among measures, queries or be defined at the model level.
Posted Date:- 2021-09-26 22:48:28