Forum Discussion

asparagus1_'s avatar
asparagus1_
Helper I
4 months ago
Solved

Parameter table dimensions - summarize

Hi, I have a parameter table that lets users dynamically choose a dimension (e.g., product category, product family, etc.), which changes how the data is sliced in a visual. I’d like to calculate a...
Need Help
  • danextian's avatar
    danextian
    4 months ago

    Field parameters aren’t actual columns, so they can’t be used directly inside SUMMARIZE. They act more like a dynamic dimension selector. To work with the selected field, create a conditional measure that responds to the chosen parameter value.

     

    Example:

     

    VAR _order =
    SELECTEDVALUE ( FieldParameter[Order] )

RETURN
SWITCH (
    _order,
    1,
        SUMX (
            SUMMARIZECOLUMNS (
                'Table'[Column1],
                "@value", [The Measure]
            ),
            [@value]
        ),
    2,
        SUMX (
            SUMMARIZECOLUMNS (
                'Table'[Column2],
                "@value", [The Measure]
            ),
            [@value]
        ),
    3,
        SUMX (
            SUMMARIZECOLUMNS (
                'Table'[Column3],
                "@value", [The Measure]
            ),
            [@value]
        )
)
Kedar_Pande's avatar
Kedar_Pande
Super User
4 months ago

asparagus1_ 

 

Field Parameters + ALLSELECTED total:

Dynamic Total = 
SUMX(
ALLSELECTED(ParameterTable),
CALCULATE([YourMeasure])
)

Matches visible table total exactly

If this answer helped, please click 👍 or Accept as Solution.
-Kedar
LinkedIn: https://www.linkedin.com/in/kedar-pande