topic DAX query for alternative of what if parameters in DAX Commands and Tips

DAX query for alternative of what if parameters

zainqazi96 — Thu, 22 Feb 2024 08:25:24 GMT

Hi Guys!

I'm encountering an problem in which i want to acheive what if parameters functionality because i'm using Report server and it won't work on RS , i need to use same working like pattern , now if i want to get all the values of a column in a measure how can i do it just like SQL query in which e.g select col1 from tab1; i want to achieve same thing in dax

Re: DAX query for alternative of what if parameters

Sahir_Maharaj — Thu, 22 Feb 2024 08:48:49 GMT

Hello zainqazi96,

Can you please try the following:

1. Create a Calculated Table

DistinctColumnValues = DISTINCT('TableName'[ColumnName])

2. Use the calculated table to create a slicer in your report

3. Create a Measure to Reflect the "What If" Selection

DynamicMeasure = VAR SelectedValue = SELECTEDVALUE('DistinctColumnValues'[ColumnName], "Default Value") RETURN CALCULATE( [YourCalculation], FILTER( 'TableName', 'TableName'[ColumnName] = SelectedValue ) )

Hope this helps!

Re: DAX query for alternative of what if parameters

zainqazi96 — Thu, 22 Feb 2024 09:41:06 GMT

Sahir_Maharaj i don't get it , how can i use column name in slicers , based on dynamic selections

Re: DAX query for alternative of what if parameters

Anonymous — Fri, 23 Feb 2024 07:16:53 GMT

Hi zainqazi96 ,

You can use reference in the power query first and then convert the table by unpivot column and remove the unwanted columns.

then create below formula in powerbi, enabling dynamic selection of column name in the slicer.

slicer_by_columnName = VALUES('Table (2)'[Attribute])

Best Regards,
Adamk Kong

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.