Forum Discussion
Solved
count specific text in a row
Dear Team, I have a table Column 1 Column 2 Column 3 Column 4 Column 5 Column 6 Count of NotCompleted Completed NotCompleted Completed NotCompleted NotCompleted Completed 3 ...
HI asodhani
If you don't mind a bit of hardcoding this calculated column will work
Column = VAR S = "NotCompleted" RETURN IF('Table3'[Column 1]=S,1) + IF('Table3'[Column 2]=S,1) + IF('Table3'[Column 3]=S,1) + IF('Table3'[Column 4]=S,1) + IF('Table3'[Column 5]=S,1) + IF('Table3'[Column 6]=S,1)Otherwise, unpivot the data to rows and you can sum over a single column
Hi asodhani
Please give this a try.
Column = IF('Table3'[Column 1]="NotCompleted",1) + IF('Table3'[Column 2]="NotCompleted",1) + IF('Table3'[Column 3]="NotCompleted",1) + IF('Table3'[Column 4]="NotCompleted",1) + IF('Table3'[Column 5]="NotCompleted",1) + IF('Table3'[Column 6]="NotCompleted",1)
Phil_Seamark
Microsoft Employee
Microsoft EmployeeHI asodhani
If you don't mind a bit of hardcoding this calculated column will work
Column =
VAR S = "NotCompleted"
RETURN
IF('Table3'[Column 1]=S,1) +
IF('Table3'[Column 2]=S,1) +
IF('Table3'[Column 3]=S,1) +
IF('Table3'[Column 4]=S,1) +
IF('Table3'[Column 5]=S,1) +
IF('Table3'[Column 6]=S,1) Otherwise, unpivot the data to rows and you can sum over a single column
I can only do VAR.S but then it asks me for a column name. also I am unsure how to add the Return Formula after that.
Will be great if you can assist
- Phil_Seamark
- Phil_Seamark
Hi asodhani
Please give this a try.
Column = IF('Table3'[Column 1]="NotCompleted",1) + IF('Table3'[Column 2]="NotCompleted",1) + IF('Table3'[Column 3]="NotCompleted",1) + IF('Table3'[Column 4]="NotCompleted",1) + IF('Table3'[Column 5]="NotCompleted",1) + IF('Table3'[Column 6]="NotCompleted",1)