Advance your Data & AI career with 50 days of live learning, dataviz contests, hands-on challenges, study groups & certifications and more!
Get registeredGet Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now
the two table has no relationship, and I want to make the calculation return blank when look at "column" dimension, how to write the dax? thank you.
here is the two tables:
here is the dax and result, I want the sum calculation do not show when unrelated table is there:
CAL=calculation(sum(table[value]))
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
Check out the October 2025 Power BI update to learn about new features.