Is it possible to hold a column in a Measure variable?

Anonymous Sorry, having trouble following, can you post sample data as text and expected output?

Not really enough information to go on, please first check if your issue is a common issue listed here: https://community.powerbi.com/t5/Community-Blog/Before-You-Post-Read-This/ba-p/1116882

Also, please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

The most important parts are:
1. Sample data as text, use the table tool in the editing bar
2. Expected output from sample data
3. Explanation in words of how to get from 1. to 2.

Hey Anonymous ,

 

there is no such thing as a dynamic table expression that can be used or re-used across different measures. For this there will be fractions of code that will repeat.

As the DAX function IF returns either a boolean value, or a scalar value, but never a table. A simple DAX statement to create a measure can become more complex.

Starting with this

the measure I want = 
CALCULATE(
    <the scalar value>
    , settablefilter1
    , settablefilter2
    , ...
    , settablefilterN
)

transforms into something like this

the measure I want = 
var _slicer1 = SELECTEDVALUE(...)
var _slicerN = SELECTEDVALUE(...)
return
CALCULATE(
    IF(_slicer voodod , the maybe hidden measure1 , the maybe hidden measure2)
    , settablefilter1
    , settablefilter2
    , ...
    , settablefilterN
)

I consider the measures "measure1" and "... measure2" base measures, these measures do not repsond to slicer selection, but simply calculate the value for local or USD. Be aware that "_slicer voodoo" represents logic that helps to determine on of the "maybe hidden base measures".

 

Basically we got the numeric expression part covered.

A final measure, reflecting on myriads of possible slicer combinations may look like this:

the measure I want = 
var _slicer1 = SELECTEDVALUE(...)
var _slicerN = SELECTEDVALUE(...)

var _check1 = IF( _slicermojo , 1 , 0)
var _check2 = IF( _slicermojo , 0 , 1)

return
CALCULATE(
    IF(_slicer voodod , the maybe hidden measure1 , the maybe hidden measure2)
    , AND( _check1 = 1 , FILTER('<Table1 1>' , ...)
    , AND( _check2 = 1 , FILTER('<Table1 2>' , ...)
    , ...
    , settablefilterN
)

You have to make sure that _check1 and _check2 can never have the same value at the same time.

As IF will be evaluated lazily, the second parameter of the AND above will never be evaluated if the the 1 parameter equals FALSE, this prevents the unwanted application of the FILTER(...) function.

 

Hopefully, this provides some ideas on how to tackle this challenge.

 

Regards,

Tom