Forum Discussion

elsteshepardo's avatar
elsteshepardo
Frequent Visitor
2 years ago

Using a Measure or a Variable in a Measure doesn't work - but the Number does?

I'm trying to replicate another great Bas power bi visual - it's the status tracker, but it's giving me a problem that I just don't understand.   This is his original code (using my tables)   Dum...
Need Help
Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi  elsteshepardo ,

 

Is it possible that getting 'Status'[Status]=maximum value of current DS Requests'[Status]'Status'[Order]) is itself less than or equal to 6, so it all comes up with the same result when it comes to the IF() function

 

The use of Var() function: you can temporarily save the value of the expression output in the form of a named variable, then you can pass it as a parameter to other metrics, and mesaure display a single value is different, var() can save a single value, you can save a whole virtual table of data, the value displayed is unchanged.

For more details about VAR, you may read the REMARKS:

https://docs.microsoft.com/en-us/dax/var-dax 

[DAX] Why and how to use variables - Microsoft Fabric Community

Variables in DAX - SQLBI

 

 

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

elsteshepardo's avatar
elsteshepardo
Frequent Visitor
2 years ago

Hi Anonymous 

Not sure - all I know is that the result I want to achieve only works when I enter a number, rather than use some kind of function

Being consistent with the above post - using 6 in the Measure (which is equal to Approved to next stage) I get this result

But when I use something else, like

VAR _Selected_Status_Nr =
CALCULATE(MAX('Status'[Order]),'Status'[Status] = _Selected_Status)

It doesn't work, I get this

But I know that the calculation is correct, because

CALCULATE(MAX('Status'[Order]),'Status'[Status] = _Selected_Status)

for this example, returns 6