topic Re: HELP! Power BI Permutation Problem in DAX Commands and Tips

HELP! Power BI Permutation Problem

PowerBIJR — Fri, 14 Apr 2023 08:36:32 GMT

Kudos to all power BI Professional, need some help here.

I have 2 tables:

1 tables contain a column with 4 digit number say 1234

I have another table with a column that contain all the permutation of number 1234 such as 1234,4321,2341,4123,3142,2143 and so on.

What i'm trying to achieve here is when i select the slicer value to 1234
Another visual will suggest all the related permutation 234,4321,2341,4123,3142,2143 so that i can pick each of them and display it on a visual bar chart, instead of me loccate individually what are the permutation of 1234.

Any suggestion that are able to check the related permutation solution is much appreciated!

Re: HELP! Power BI Permutation Problem

johnt75 — Fri, 14 Apr 2023 08:54:18 GMT

Transform your data so that instead of having an index value and a list of comma separated permutations you instead have a row for each index value & permutation combination. Then you can just link the slicer to the index column and that will display all the combinations.

Re: HELP! Power BI Permutation Problem

PowerBIJR — Mon, 17 Apr 2023 07:59:38 GMT

Hi Johnt75, this seems like a good idea but i how do i perform the matching value ?

<Index Table> Permutation1 Permutation2 Permutation3

1234 3412 3124 2314

this should be the result for the solution you're suggesting but since i have 2 seperate table for the index table and permutation value, i couldn't find a way to match the value and compute such a table as suggested, any idea ?

Re: HELP! Power BI Permutation Problem

johnt75 — Mon, 17 Apr 2023 08:40:44 GMT

In Power Query select the index column and then choose "unpivot other columns" so you are left with a table like

Index column	Permutation
1234	3412
1234	3142
1234	2314

You then set up a one-to-many relationship from your main data table to this new table and put the permutation column from this table into your visuals.