Supplies are limited. Contact info@espc.tech right away to save your spot before the conference sells out.
Get your discountScore big with last-minute savings on the final tickets to FabCon Vienna. Secure your discount
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)}
Solved! Go to 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.
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.
User | Count |
---|---|
13 | |
8 | |
8 | |
7 | |
5 |
User | Count |
---|---|
21 | |
15 | |
15 | |
10 | |
7 |