Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

Tableau's FIXED into DAX

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)}

Need Help
  • Dangar332's avatar
    Dangar332
    2 years ago

    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.

1 Reply

  • Dangar332's avatar
    Dangar332
    Resident Rockstar
    2 years ago

    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.