topic Re: Count similar strings within a query (example input and output in description) in DAX Commands and Tips

Count similar strings within a query (example input and output in description)

Anonymous — Fri, 03 Jun 2022 15:15:04 GMT

Hey everyone, I'm looking for help creating a DAX equation to find the same value over a given power query and count the amount of times it appears.

Any ideas or ways to go about this.

The image attached shows an example of a given table and what the desired result is.

Any advice or ideas are welcome.

Re: Count similar strings within a query (example input and output in description)

daXtreme — Fri, 03 Jun 2022 17:25:12 GMT

Input data is not in a format suitable for Power BI. Please unpivot the table first using Power Query so that the columns' names become a column themselves. Then the task will be as easy as a, b, c... Your measure will be simple as well: countrows( T ).

Re: Count similar strings within a query (example input and output in description)

Anonymous — Tue, 07 Jun 2022 06:24:40 GMT

Hi Anonymous ,

Here are the steps you can follow：

1. Go to the power query and select all three columns – Unpivot Columns.

Result:

2. Select the matrix Visual, and place the column [Value] into Rows and Values respectively

And in the Values column, set it to Count..

3. Result:

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

Re: Count similar strings within a query (example input and output in description)

Anonymous — Thu, 09 Jun 2022 12:27:28 GMT

Thank you for the help on this. Your method didn't fully solve it the way I needed it however with the unpivoted columns I was able to GROUP the similar texts and sum the quantity value on the same row.

Example: