How to achieve same functionality as field parameters by writing DAX?

Question

Hi All,&nbsp;As "field parameter" option is not available in PBIRS desktop version. I'm trying to achieve same functionality by writing DAX. But no success.&nbsp;Googled and searched in forums, can't find relevant answer.&nbsp;I have created a reference "Selection_Table"&nbsp;as below&nbsp;&nbsp;MY DAX looks something like this:-----Selected Values = VAR SelectedDim = SELECTEDVALUE(Selection_Table[DimColumn])RETURN&nbsp; &nbsp; SWITCH(&nbsp; &nbsp; &nbsp; &nbsp; SelectedDim,&nbsp; &nbsp; &nbsp; &nbsp; "Category", SELECTEDVALUE('Dim Category'[Category]),&nbsp; &nbsp; &nbsp; &nbsp; "Country", SELECTEDVALUE('Dim Country'[Country]),&nbsp; &nbsp; &nbsp; &nbsp; "Date", SELECTEDVALUE('Dim Date'[Date]),&nbsp; &nbsp; &nbsp; &nbsp; BLANK()&nbsp; &nbsp; )&nbsp;I'm getting an error and not sure if this can be possible with DAX.&nbsp;Regards,SPB&nbsp;&nbsp;

idrissshatila · Accepted Answer

Hello&nbsp;SPBKA&nbsp;,
&nbsp;
check the concept of calculation groups
https://youtu.be/vlnx7QUVYME?si=LBuBt5vxfans1NHd
&nbsp;

Forum Discussion

How to achieve same functionality as field parameters by writing DAX?

1 Reply

Related content

Decimal Parameters in User Defined functions (UDF)

Fabric User Data Function parameter defaults?

null input parameters custom function

Parameters FabricVariablesClient and FabricLakehouseClient in one udf function

Parameter in summarize