Forum Discussion

rvcedd's avatar
rvcedd
Helper I
6 years ago
Solved

Pass Measure to DAX FIND function

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 

 

Need Help
  • v-gizhi-msft's avatar
    v-gizhi-msft
    6 years ago

    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

3 Replies

  • v-gizhi-msft's avatar
    v-gizhi-msft
    Community Support
    6 years ago

    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

  • Soumyaranjan15's avatar
    Soumyaranjan15
    Regular Visitor
    4 years ago

    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