Tableau's FIXED into DAX

[Anonymous]

How do I convert the below tableau's calculated field into DAX? I dont want to create a column for it. I want to use this field as a filter in the report.

{FIXED [VisitId]:

SUM( IF CONTAINS([QuestionText], "Did you test the terminal?")

THEN
IF ([AnswerText] = "Yes")

THEN 1 END END)}

[Dangar332 · Accepted solution]

Hi, @Anonymous 

Try below measure for Your problem

FIXED VisitId=
var a = if(
         CONTAINS(
             Tablename,
             Tablename[QuestionText],
             ("Did you test the terminal?")) && Tablename[AnswerText] = "Yes",
             1
         )

In Power BI you can't direct use measure as filter(Slicer) for that you need to use Field parameter
Refer LINK  for  Field parameter

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.