Forum Discussion

Giancarlo's avatar
Giancarlo
Regular Visitor
7 years ago
Solved

search function dynamic

Hello,   I need to calculate someting like plannedDayQty = CALCULATE(COUNTROWS(day);SEARCH("2";day[weekPlan];;0))  how can I enter the dynamic day value with the report date filter? example: p...
Need Help
  • v-jiascu-msft's avatar
    v-jiascu-msft
    7 years ago

    Hi Giancarlo,

     

    Try this one, please.

     

    plannedDayQty =
VAR selected =
    SELECTEDVALUE ( 'calendar'[DayOfWeekNumber] )
RETURN
    CALCULATE ( COUNTROWS ( day ); SEARCH ( selected; day[weekPlan];; 0 ) )

     

    Best Regards,

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Ciao Giancarlo
If understand correctly you have to make the "2" in the SEARCH dynamic?
If so create a table with your values, put that in a slicer and use SELECTEDVALUE(Yourtableslicer[column]) in place of the 2.

 

unless i haven't understood ...

  • Giancarlo's avatar
    Giancarlo
    Regular Visitor
    7 years ago

    Thanks but...

    A 'SELECTEDVALUE' function was used in a True / False expression used as a table filter expression. This is not allowed.

     

    I used

    plannedDayQty = CALCULATE(COUNTROWS(day);SEARCH(SELECTEDVALUE('calendar'[DayOfWeekNumber]);day[weekPlan];;0))
    • v-jiascu-msft's avatar
      v-jiascu-msft
      Microsoft Employee
      7 years ago

      Hi Giancarlo,

       

      Try this one, please.

       

      plannedDayQty =
VAR selected =
    SELECTEDVALUE ( 'calendar'[DayOfWeekNumber] )
RETURN
    CALCULATE ( COUNTROWS ( day ); SEARCH ( selected; day[weekPlan];; 0 ) )

       

      Best Regards,

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago
      If you have such an error, don't use calculate(measure, rule) but calculate(measure, filter(table, rule))