Conversion of Calculated Column to Measure

[Anonymous]

Hello! I am new to power BI and would like to transform a calculated column into a measure in order for a slicer to work. 

I have 2 tables: 

Tested                   Applicable

a                            b

a                            c

a                            d

Meaning if a is tested then it can also be applicable to b, c and d 

Tested        Test                  Result 

a                 line                   good

a                 circle                 bad

a                 square               same

b                 line                    bad 

c                 line                     same

If the user selects b, i would like for it to get the results for b for the specific test type while still getting the results for a for the others. 

I first decided to make a calculated column which gets the results based on test type and tested, but apparently it won't update based on the user selection. I would need it to update based on user selection. 

Thank you! 

[v-alq-msft]

Hi, @Anonymous 

Could you please explain the logic and show the expected result based on your original post? 

Best Regards

Allan

[amitchandak]

@Anonymous ,The information you have provided is not making the problem clear to me. Can you please explain with an example.
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
Appreciate your Kudos.

[lbendlin]

highlight the calculated column, save the code somewhere in a text editor, delete the calculated column, create a new measure, paste the code.

Then you may have to adjust it a bit depending on your circumstances as you are now moving from row context to filter context.