Forum Discussion

HarsimranPWRBI's avatar
HarsimranPWRBI
Helper I
6 years ago

Problem With DAX Evaluate Command

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

4 Replies

  • vishanshul's avatar
    vishanshul
    Frequent Visitor
    6 years ago

    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's avatar
      HarsimranPWRBI
      Helper I
      6 years ago

      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