topic Re: DAX query error handling in DAX Commands and Tips

DAX query error handling

UNIheve — Thu, 23 Nov 2023 07:14:06 GMT

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

DEFINE
VAR a = [b]
EVALUATE
{a}

Re: DAX query error handling

lbendlin — Fri, 24 Nov 2023 17:40:09 GMT

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

Re: DAX query error handling

UNIheve — Mon, 27 Nov 2023 07:40:48 GMT

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.