DAX query error handling

[UNIheve]

Hi

Is it possible to error handle a case, where the measure [b] doesnt exist in the model?

DEFINE
VAR a = [b]
EVALUATE
{a}

@Greg_Deckler 

[UNIheve]

@lbendlin Thanks. I will vote 🙂

Cause yes, it is important.
I query multiple SSAS cubes (dev-test-prod) automatically via users acceptance criteria, that is, some values from measures, that the user states as correct in a certain filter context.
From the users input in validated Excel sheets, DAX evaluation strings are constructed to return a calculatede value like  DEFINE var a = CALCULATE ( <meausure>, <filtercontext> ) EVALUATE {a}. The calculated value is then compared with the expected value.
If the measure eg. is not yet in production, I dont want the evaluation to fail.
Not being able to error handle, I must load and join with all measure metadata from all cubes (20 at the moment) to test if the measure is present.

[lbendlin · Accepted solution]

Not currently possible. If this is important to you please consider voting for an existing idea or raising a new one at https://ideas.fabric.microsoft.com/?forum=2d80fd4a-16cb-4189-896b-e0dac5e08b41