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
Why does this calculated column return an empty value, for rows that are equal to zero?
Number of Rows =
VAR ThisIndex = 'Table'[Index]
RETURN
COUNTROWS(
FILTER('OtherTable', 'OtherTable'[col] = ThisIndex)
)
Solved! Go to Solution.
@webportal , for no rows it will return blank, you can add +0 if needed
Number of Rows =
VAR ThisIndex = 'Table'[Index]
RETURN
COUNTROWS(
FILTER('OtherTable', 'OtherTable'[col] = ThisIndex)
) +0
@webportal , for no rows it will return blank, you can add +0 if needed
Number of Rows =
VAR ThisIndex = 'Table'[Index]
RETURN
COUNTROWS(
FILTER('OtherTable', 'OtherTable'[col] = ThisIndex)
) +0
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.