Measure to count columns that have the same strings of text in a different order
Hey Folks, I have a column of data that contains a topic or multiple topics that are seperated by ";" that may be in a different order. I'm trying to count the times particular combinations of topics are put together, i.e. As appears in regular table count Topic 1;Topic 2;Topic 3 - 1 Topic 3;Topic 1;Topic 2 - 1 Topic 4 - 1 Output I'm trying to get to: Topic 1;Topic 2;Topic 3 - 2 Topic 4 - 1 I have found the following solution on Stack Overflow that seems to be exactly what I'm talking about, however the context is for other databases than PowerBI / Power Query. r - Group strings that have the same words but in a different order - Stack Overflow I'm hoping that this is something that can be acheived via a measure rather than within power query. I already have a bridge table that lists all individual topics, so I'm wondering if its something I might be able to leverage as part of the meaure, but I'm very lost on this presently. Thank you for your help.Help with filtering table based on filter string
I hope someone can help with this problem. So I'm trying to create a DAX measure, that needs to filter some account numbers in a table based on a string. The string contains both ranges and specific account numbers, and looks like this: 01011..01090|01901..01902|01904..01959|01980..01998 I can then fetch that value in my measure with this variable: VAR FilterString = CALCULATE( SELECTEDVALUE( 'Account Schedule'[Totaling]), 'Account Schedule'[Row No_] = "01090" ) However, how do i then translate that string into a useable filter?
