Can you use multiple what if parameters to create a unique ID to filter another table?

[pirtlede]

HI,

I am trying to use what if parameters with the thought of creating a unique identifer that will allow me to filter another table.  I have searched for solutions but have not found anything that directly meets the expected solution.  I am beginning to think my approach is not supported in Power BI.  

Here is a screenshot of my page.  You will see two what if parameters that is used to define a calculated column for the criteria.  The best option would be to just concatenate the two sets of criteria.  I am open to any ideas you have.

This example would have a unique ID of 'YesNoNoNoNoNoNoYesNoNo'

Thanks

Doug

[amitchandak · Accepted solution]

@pirtlede , what if parameter can not be used in calculated column