Pass Measure to DAX FIND function

[rvcedd]

Hi all,

I would like to pass a DAX Measure as a parameter to the SEARCH Function. However, this does not seem to work. Please see example below. 

https://1drv.ms/u/s!Avv4DxzuMuq2kckFD3Xai4HIo3qk0w?e=KPgzPs

I would have expected that the output of the table is as follows when FieldID = "D" is selected. Can anyone help? PowerBI attached.

A, 1

B, 3

C, 0 

D, 0 

[Soumyaranjan15]

I have a measure that calculates this value based on the row. I have concatenated the value and its change %. How can I apply color on the result as if the value contain "-" then make the value red, if + then  green

Thanks for your help

[v-gizhi-msft · Accepted solution]

Hi,

It is because calculated column can not dynamically be changed by slicer selected.

Please try this measure:

New FieldIDinWithin5Selected = FIND(SELECTEDVALUE(Sheet2[FieldID]),MAX(Sheet1[Within5]),,0)

When you select 'D' in slicer, it shows:

Here is the changed pbix file:

pbix 

Hope this helps.

Best Regards,

Giotto Zhi

[amitchandak]

Can not access data error