Forum Discussion

LaurensM02's avatar
LaurensM02
Regular Visitor
2 years ago

Countrows in multiple column based on partial text value

Dear all,   For a project I need to be able to count the number of rows in a file, based on a text value in one of eight defined columns. I want to count a row when one of the "Linked Issues" colu...
Need Help
Tips and Tricks
LaurensM02's avatar
LaurensM02
Regular Visitor
2 years ago

Hi Thejeswar,

 

Thanks for your quick response. I am using the measure for a card visual that shows the total number of rows that meet the filter conditions. So the output should eventually be a number.

 

Also I tried using a wildcard character in the text value, since the filter needs to count every row where one of the Linked Issues columns contain a value that starts with "THGRW-", but I could not get that working.

Thejeswar's avatar
Thejeswar
Super User
2 years ago

LaurensM02 ,

You can convert your table to look like below using Unpivot Columns option in Power Query Editor

 

Refer below link

Unpivot Columns in Power BI 

 

Post that you can use the below DAX to get the ouput that you were expecting. In this case there are 5 combinations having "THGRW" in them

 

  • LaurensM02's avatar
    LaurensM02
    Regular Visitor
    2 years ago

    I have a strange problem before I want to start unpivotting columns. The following formula gives me the correct number of rows. But whenever I change it to [Linked Issues.2] or another number, the formula returns a blank.