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
Hello
Is there any way to make "_dimension" assigned in this case to "values" can be variable, that is, that as I have selected in a swich / if I take one column or another?
IF r=1 _dimension = "DIM TABLE 1"
IF r=2 _dimension = "DIM TABLE 2"
IF ( r = 1, RELATED('dim1[fieldx]),
If (r = 2, RELATED('dim2[fieldy]),
"unknown value of r"
)
)
Proud to be a Super User! | |
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!