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! I was having the same issues, I was never able to figure out exactly why the DAX code does not work as intended. However, I did find a work around. 

 

Using transform data I  took the Status Column (Info like "Waiting for approval", "Shipping", etc) and I added a conditional column that esentially converts the status information to the same information as you have in the 'Status'[Order] Column. Because of the nature of my data I had to do a couple other steps. However, I think you should be able to use this new column as your _Selected_Status_Nr possibly with selected value (assuming you are using a slicer like he did in the video?

 

Dummy Line Highlight2 =
VAR _Selected_Status_Number = insert formula for grabbing number from condition column (possibly using SELECTEDVALUE function)

RETURN
    IF(
        MAX('Status Table'[Index]) <= _Selected_Status_Number,
        [Dummy],
        BLANK()
    )

 

I am no Power BI expert, but I think what solved the porblem for me was using a table value for this variable rather than a measure value.

 

Hope this helps!