Use the results of on DAX as a single value number in another

[DebbieE]

I have created some DAX to create a measure which works perfectly as a single value card

I want to use the result in another bit of DAX (Measure) but when I use it it seems to add the filters from the low level DAX to the top level DAX.

Is there anyway to Return the Single value without any of its filters. In the same way as you would copy a value in Excel and Paste as values

If I 'Hardcode' the same value for the top level DAX it works perfectly

[jairoaol]

DAX measures are always assessed according to the context in which they are used, so you should always take this functionality into account.

to resolve the issue on time, keep in mind:

• Items that the card takes into account to show the value
• Apply those same elements to the new DAX formula to get the same result always, no matter the context where you use it in other visualizations.
• Change the context of the DAX formula using functions such as ALL, ALLSELECTD, KEEPFILTERS, and REMOVEFILTERS

[CNENFRNL]

Hi, @DebbieE , did you ever try to author a new measure including the old new this way?

New Measure = 
VAR __old_measure = CALCULATE ( [Old Measure], ALL(CetainTables or Columns) )
...

As you know, measures are extremely sensitive to evaluation context, it's really hard to pinpoint a solution without taking a close look at your data model and viz.

[DebbieE]

I have already tried that. I thought there may be some DAX that literally converts to values, like you get in Excel

I already have an open question containing the actual DAX. I just added this one to see if there was a simple answer but I dont think there is unfortunaltey

[v-jingzhang]

Hi @DebbieE  , every time when a measure is used, no matter singly used or used in other DAX codes, it will be evaluated according to its current context. The result of a measure will not be stored in the model, so there is not a static measure value to be used somewhere else.