Help with Power Query to create a calculated column based on multiple selection in slicer

[Anonymous]

Hi

I have slicer that has mutilple values selected from Table A

I have another TableB and want to create a column based on the multiple values selected in TableA comparing with columnB in TableB.

Any idea to do this in DAX or PowerQuery will be appreciated.

Thanks in advance

CheenuSing

[Greg_Deckler]

Not a lot of information here. If creating something based on slicer selection, you will need to create a measure in DAX. Is there a relationship between the 2 tables? Can you provide some sample data?

[Anonymous]

Hi @Greg_Deckler

Thanks for the reply.

Here is the link of the pbix file

https://1drv.ms/u/s!ApP3mBZyGaHfzzHsZtcBCNqlp71-

Cheers

CheenuSing

[Anonymous]

hi @Greg_Deckler

Any solution you could come out with ?

Basically I want to compute the Average Salary of all records in Activity table whose Combined column value contains the selected values of SkillsType[Skill].

The SkillSet table contains the extracted values of essential skills, desriable skills from Activity table which are comma separated into multiple recrods by id.

If there is way to compare the SkillSet table value column with the selected values of SkillsType[Skill] and create a calculated column SkillSet table as 1 or 0 depending on selected or not. Then we can filter the Activity table id by those ids in SkillSet that have value 1.

Cheers

CheenuSing

[Phil_Seamark]

Hi @Anonymous

I'd merge your 'SkillSet' and 'Activity' table into 1 table in the query editor using the Merge function.

I'd also switch the relationship between 'SkillsType' and 'Skillset' back to single dir.

From here, any selections made on a slicer using the 'SkillsType' table will automatically filter rows in Activity for any Average calculated measures you make.  This sounds like enough, but if not, can you please give a more specific example of some skills selected, and what numbers you expect to see.

[Anonymous]

Hi Phil,

The SkillSet is a dervied data set from Actitivity by spliiting the desrialbeSkills and essentialSkills separated by comma into mutiple rows per id.

The Activity data set will run into millions of records just to give an indication it runs into 5 million records for a period of 6 months.

So any other workaround please suggest.

Cheers

CheenuSing