topic Re: Comparing a column with 2 slicer on an other column in DAX Commands and Tips

Comparing a column with 2 slicer on an other column

al12397 — Sun, 12 Apr 2020 22:22:19 GMT

Hi Everyone,

New power BI user here. Basically what I want to do is have a user select 2 values on same column and have the output be the common IDs on another column

Selections	IDs
A	One
B	two
C	Three
D	One
E	Two
F	Three
G	One
H	Two

Suppose a user selects in a Slicer1 "A" and "B" and in Slicer2 "G" then I want to output to show (in matrix or whatever) "One"

Suppose a user selects in slicer1 "C" and in Slicer 2 "D" then the output should be nothing

Suppose a user selects in Slicer1 "A","B","C" and in Slicer2 "B","F" then output should be "two" and "three" etc

Ideally I dont want to dublicate tables/columns (but can live with it if there is no other way) as its a large data set and dont want to affect performance.

Thanks.

Re: Comparing a column with 2 slicer on an other column

Anonymous — Mon, 13 Apr 2020 02:56:10 GMT

There is no way to do it with just a single table. You have to have 2 independent dimensions from which to make selection 1 and 2. No way around it.

Best

Re: Comparing a column with 2 slicer on an other column

al12397 — Wed, 15 Apr 2020 02:22:49 GMT

Thanks for the reply.

One quick question is assume I cannot create a realtionship between the 2 filter tables (and cannot go to qurey editor to create a relationship) and the Main table is there a way to do this then?

Re: Comparing a column with 2 slicer on an other column

Anonymous — Wed, 15 Apr 2020 09:30:15 GMT

There are also other ways to set up this model. You can, for instance, have all the 3 tables disconnected from each other. Then you'll need to make changes to the measure to make it work the same. You can also create 2 active connections to the main table but you'll need to make a change to the measure as well. But connecting the selection tables... does not serve any purpose and, indeed, it's just wrong. Try it yourself.

Best
D