Can Tabular Editor 3 read parameter values?

[UBComma]

Does anyone know if Tabular Editor is able to read parameter values from the model?

I am creating a Power BI model that is made up primarily of parameter values that interact with each other. There are no data tables in the model other than a list of years. I like to write DAX in Tabular Editor but it doesn't seem to read SELECTEDVALUE when I have a slider selection in the model. For example, I have a measures like this:

Total Gross Square Feet Value = SELECTEDVALUE ( 'Total Gross Square Feet'[Total Gross Square Feet] , 999)

and 

Cost/SF Level 1 Value = SELECTEDVALUE ( 'Cost/SF Level 1'[Cost/SF Level 1], 100 )

So I write a another measure that multiplies the two together:

Cost Level 1 = [Total Gross Square Feet Value] * [Cost/SF Level 1 Value]

If I run this in Tabular Editor, and put the result in { }, it does not return a value, but it works fine in PBI. So, I am just wondering if there's a way to get TE to read the parameter values, or if that's not possible.

Thanks in advance (BTW, I'm using TE3)

[johnt75 · Accepted solution]

I don't think its possible for Tabular Editor to read the selections in slicers, but you can simulate it using TREATAS and variables. e.g. if you had a date slicer and a color slicer you could emulate the user selections with something like

DEFINE
    VAR myFilter =
        TREATAS (
            { ( 2022, 6, "Red" ) },
            'Date'[Year],
            'Date'[Month number],
            'Product'[Colour]
        )

EVALUATE
SUMMARIZECOLUMNS ( 'Product'[Brand], myFilter, "Sales Amount", [Sales Amount] )

You can use multiple filters in SUMMARIZECOLUMNS, so you could potentially have one filter per slicer rather than combining them.

[UBComma]

@johnt75 , Thanks, that's a great suggestion and will work for what I'm trying to do. I appreciate your input!