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!Avv4DxzuMuq2k...
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

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