Count text by rows

[Anonymous]

Hi all,

I am new to PowerBI and want to take a count of text completed in all the rows. Please help me with the DAX function to do the same.

Searching for similar function in PowerBi as In Excel  COUNTIF(A1:B1,"Completed")

[negi007]

@Anonymous 

you could write your measure like below

Count_Value = CALCULATE(COUNT(Table[Customer]),Table[Customer_Status]="Completed")

[Anonymous]

Hi,

Thanks for your reply but it would not count "Completed" in range of 6 columns. I want to get the total number of times "Completed" is found in single row and 6 columns.

for example i want to get the number of "Completed" in Row1 ColumnB to ColumnG.