also if you want to select dimension and measure together in a single parameter then you can create dimension of a measure using subquery and cte in sql.for example:1. Create a dimension parameter parameter: dimension_selection{ type: unquotedallowed...

You can use parameters this way to implement KPIs on Selection only:1. Create a parameter to select different measures at a time:parameter: measure_selection{ type: unquotedallowed_value: {label: "Sales"value: "Total_Sales" --[name of sum(measure)]}a...