Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Convert value from measure to a Constant Value

Hi,   Not sure why this happens.   I have a variable measure that gives me the expected value, but doesn't perform as expected when plugged into the main measure. When I hardcode the same variabl...
Need Help
Show and Tell
  • parry2k's avatar
    parry2k
    5 years ago

    selimovd looking at the measure, it will not work because you are using only one column in ALL function and it will fail to filter Intensity column. Just my 2 cents.

  • v-kelly-msft's avatar
    v-kelly-msft
    5 years ago

    Hi  Anonymous ,

     

    Modify your variable as below:

     

    Variable1 =
SUMX (
    FILTER (
        ALL (maintable[position],maintable[intensity]),
        maintable[position] = 1
            && maintable[intensity] = 0
    ),
    maintable[Value]
)

     

     

    Best Regards,
    Kelly

    Did I answer your question? Mark my post as a solution!

parry2k's avatar
parry2k
Icon for Super User rankSuper User
5 years ago

selimovd looking at the measure, it will not work because you are using only one column in ALL function and it will fail to filter Intensity column. Just my 2 cents.

  • selimovd's avatar
    selimovd
    Icon for Most Valuable Professional rankMost Valuable Professional
    5 years ago

    Hey parry2k ,

     

    you're absolutely right. I Didn't test the function. I found the approach with CALCULATE and SUMX unusual, so I tried a quick fix. But you're right, like this it won't return a table.

     

    Best regards

    Denis