topic Re: Is there any way to pass measure in field parameter instead of normal measure? in DAX Commands and Tips

Is there any way to pass measure in field parameter instead of normal measure?

firstch — Sun, 24 Jul 2022 11:56:33 GMT

Hi, all
I really want to ask that Is there any way to pass measure in field parameter instead of normal measure
For example

Thankyou

Best Regard
firstch

Re: Is there any way to pass measure in field parameter instead of normal measure?

Fowmy — Sun, 24 Jul 2022 13:24:14 GMT

firstch

Cannot think of a more efficient approach than this but should work. Incoorporate this code within your measure

VAR __PARAM = SELECTEDVALUE( Parameter[Parameter Order] ) RETURN SWITCH( TRUE(), [Filed Measure 1] = __MAXSALES && __PARAM = 0 , "COLOR CODE1", [Field Measure 2] = __MAXSALES && __PARAM = 1 , "COLOR CODE1", "COLOR CODE2" )

Re: Is there any way to pass measure in field parameter instead of normal measure?

firstch — Mon, 25 Jul 2022 04:35:05 GMT

Dear Fowmy
Its work ,thankyou very much

Best Regard
firstch