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!

Anonymous's avatar
Anonymous
Not applicable
5 years ago

 

selimovd 

parry2k 

 

Here is the full Measure:

 

//This variable needs to be converted to a constant value.

 

VAR Variable1 = CALCULATE( sumx(maintable, maintable[Value]), Filter(All(maintable[position]), maintable[position] = 1), maintable[intensity]=0 )

 

RETURN

//The VAR from above is plugged into the measure below.  When Variable1 is instead hardcoded with the same fixed/contant value the measure works perfectly.  Is there a workaround?

 

if(or(SUM(maintable[position]) = 0 && sum(maintable[Value]) = Variable1,

(SUM(maintable[intensity]) = 0 && sum(maintable[Value]]) = Variable1)),

Sum(maintable[Value]) +1, Sum(maintable[Value]))

  • v-kelly-msft's avatar
    v-kelly-msft
    Icon for Community Support rankCommunity Support
    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!

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      Thank You.

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

    Hey Anonymous ,

     

    in general it's very uncommon to use SUMX within CALCULATE and also that you put some arguments in FILTER and some in the context of CALCULATE.

     

    I would do the FILTER part in the SUMX:

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

     

    Can you check if that will result in the same value?

     

    Then when you add the "Variable1" in your main measure, which of the results will be executed?

     

    If you need any help please let me know.
    If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍
     
    Best regards
    Denis