Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now

Reply
Anonymous
Not applicable

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

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'

 

pirtlede_0-1632247998793.png

Thanks

Doug

1 ACCEPTED SOLUTION
amitchandak
Super User
Super User

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

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

View solution in original post

1 REPLY 1
amitchandak
Super User
Super User

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

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

Helpful resources

Announcements
Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

October Power BI Update Carousel

Power BI Monthly Update - October 2025

Check out the October 2025 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Top Solution Authors