Forum Discussion

roncruiser's avatar
roncruiser
Icon for Post Patron rankPost Patron
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  roncruiser ,

     

    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!

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

Hey roncruiser ,

 

in Power BI there is nothing like a fixed value for a measure. 

A measure always has a filter context and is executed in that context. If you measure returns another value than when you integrate it into another value, then the context is different.

 

Can you show the main measure and how you integrate it? Also, please show some data and how you analyze (table, bar chart, etc.). That makes it easier to understand what contexts are working on a measure.

 

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