Dynamic parameter - DAX

Hi Anonymous ,

Your issue likely stems from how SELECTEDVALUE(RolesTable[Role]) is being evaluated within the parameter table. If multiple values are selected or no value is selected, SELECTEDVALUE returns BLANK(), which could cause unexpected behavior. Additionally, using NAMEOF inside an IF condition may not work as expected because NAMEOF returns a column reference as a string, but the IF function expects valid expressions.

To resolve this, try defining the logic separately in a measure and then referencing it within your parameter table.

SelectedDimension =
VAR RoleSelected = SELECTEDVALUE(RolesTable[Role])
RETURN
    IF(
        RoleSelected = "DACH Area",
        "Area",
        "Owner"
    )

Then, modify your parameter table to use this measure instead of embedding the IF logic directly.

Dimension_Cumulated = {
    ("Owner", IF( [SelectedDimension] = "Area", NAMEOF('Opp Details'[Area]), NAMEOF('Opp Details'[Opportunity Owner])), 0),
    ("TCV € Class", NAMEOF('Opp Details'[TCV € Class]), 1),
    ("Prob. Class", NAMEOF('Opp Details'[Prob. Class]), 2),
    ("Prev.Stage", NAMEOF('Opp Details'[Prev.Stage]), 3),
    ("Area", NAMEOF('Opp Details'[Area]), 4)
}

By separating the logic into a measure, the role selection will be properly evaluated before being used in the parameter table, ensuring that the correct dimension is displayed based on the filter selection.

Best regards,