Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Count text by rows

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

General Comment
Interesting Links
Need Help
Tips and Tricks

2 Replies

  • negi007's avatar
    negi007
    Community Champion
    5 years ago

    Anonymous 

     

    you could write your measure like below

     

    Count_Value = CALCULATE(COUNT(Table[Customer]),Table[Customer_Status]="Completed")
     
     
    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      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.