CONTAINSSTRING and SELECTEDVALUE in COUNT function

Question

Hello,&nbsp;I would like to ask for help as I cannot get over the problem.&nbsp;&nbsp;I have a matrix table with several measures. These measures are different calculations of contracts for different type of service. It is filtered by service name so I used CONTAINSSTRING for it. I would like to have in the table always only one type of the product and filter it by the slicer. But I do not know how to combine the CONTAINSSTRING and SELECTEDVALUE as it does not work. Below is my measure.&nbsp;Measure =&nbsp; &nbsp; &nbsp; &nbsp; CALCULATE (&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; COUNT( 'Orders'[_airtableRecordId] ),&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; CONTAINSSTRING('Orders'[Product],SELECTEDVALUE('Garance product'[Column 1])),&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 'Orders'[State] = "Fakturace" &nbsp;|| 'Orders'[State] = "Active",&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; USERELATIONSHIP ( 'Calendar'[Date], 'Orders'[Uhrazeno] ),&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 'Orders'[Uhrazeno] &lt;&gt; BLANK ())&nbsp;If I replace SELECTEDVALUE('Garance product'[Column 1]) by the string f.e. "12M NEO", it works.&nbsp;&nbsp;Thanks in advace.

lbendlin · Accepted Answer

Measure =
var s = SELECTEDVALUE('Garance product'[Column 1])
RETURN CALCULATE (
            COUNT( 'Orders'[_airtableRecordId] ),
            CONTAINSSTRING('Orders'[Product],s),
            'Orders'[State] IN { "Fakturace" , "Active"},
            USERELATIONSHIP ( 'Calendar'[Date], 'Orders'[Uhrazeno] )
)

Forum Discussion

CONTAINSSTRING and SELECTEDVALUE in COUNT function

2 Replies

Related content

Switch -Containsstring

ContainsString with OR function

Containsstring and Count

Alternative of SELECTEDVALUE DAX function

SelectedValue function not Working