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

amitchandak's avatar
amitchandak
Super User
6 years ago

Can not access data error