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([...
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.

Dangar332's avatar
Dangar332
Icon for Resident Rockstar rankResident 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.