Problem With DAX Evaluate Command

[HarsimranPWRBI]

I'm trying to evaluate DAX command via DAX Studio on Attached Model

Table Level1 is able to be evaluated only after commenting var Level3.

SS BELOW

EVALUATE LEVEL 1

Table Level3 is not evaluating

SS BELOW

EVALUATING LEVEL3

Questions:

1. Why i need to comment Level3  variable to evaluate Level1?
2. Why Level3 is not evaluating ?

Thanks,

Harry

[vishanshul]

For Evaluate Level 3 just select the var level 3 and evaluate level 3. Like we do in SQL select the statement and execute it. 

Please accept it as a solution if it solves your problem.

Thanks,

Vishal Gupta

[HarsimranPWRBI]

Hi @vishanshul ,

I'm doing same thing i believe, check the second screenshot.

Level3 var depends on level1 and finanlly evaluating only level3.

Please , Let me know if i'm missing something.

Thanks,

Harry

[AlB]

Hi @HarsimranPWRBI 

The file cannot be accessed. It requests a login.

[HarsimranPWRBI]

Hi @AlB 

I've updated the file please check again and let me know.

Thanks,

Harry