search function dynamic

[Giancarlo]

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:

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

day[weekPlan] contains multiple data like "2,4" or "2,3,4,5" etc...

[Anonymous]

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]

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 · Accepted solution]

Hi @Giancarlo,

Try this one, please.

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

Best Regards,

[Anonymous]

If you have such an error, don't use calculate(measure, rule) but calculate(measure, filter(table, rule))