topic Problem With DAX Evaluate Command in DAX Commands and Tips

Problem With DAX Evaluate Command

HarsimranPWRBI — Tue, 22 Oct 2019 05:24:27 GMT

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

Table Level3 is not evaluating

SS BELOW

Questions:

Thanks,

Harry

AlB — Mon, 21 Oct 2019 23:21:33 GMT

The file cannot be accessed. It requests a login.

vishanshul — Tue, 22 Oct 2019 05:15:22 GMT

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 — Tue, 22 Oct 2019 05:28:06 GMT

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

Thanks,

Harry

HarsimranPWRBI — Tue, 22 Oct 2019 05:32:08 GMT

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