Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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:
Solved! Go to 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.
@johnt75 , Thanks, that's a great suggestion and will work for what I'm trying to do. I appreciate your input!
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
43 | |
23 | |
21 | |
15 | |
15 |
User | Count |
---|---|
45 | |
31 | |
30 | |
18 | |
17 |