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 Ex...
General Comment
Interesting Links
Need Help
Tips and Tricks
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.