Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now
I need help with translating the function listed below to power BI
=IF(AND(Something is True, Something else is True), Value if True, Value if False)
And if it's true I want it to pull the values from a list. If the user clicks on value A, and the conditions meet then is able to display that value; if it's false then it's blank.
If anyone can guide me it would be great.
Thanks!
Katy
Solved! Go to Solution.
hi @Anonymous,
It looks like you're new to the community, welcome.
You'll likely want to make data available along with the desired outcome to get responses to your post. See @Greg_Deckler's post https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490.
I have attempted to infer your desired outcome however, see below.
Proud to be a Super User!
hi @Anonymous,
It looks like you're new to the community, welcome.
You'll likely want to make data available along with the desired outcome to get responses to your post. See @Greg_Deckler's post https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490.
I have attempted to infer your desired outcome however, see below.
Proud to be a Super User!
Hi Dozer, thank you so much for the feedback and help! Your solution definitely helped me out.
I look forward to collaborating with everyone going on forward!
Thank you!
Katy
Check out the November 2025 Power BI update to learn about new features.
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!