Counting total value of images url

[Sisko]

Hi,

I need help to calculation total value of images url. Now I have this kind of funtia, but it not work right.

Picture count = IF( ISBLANK('Table'[ImageUrls.1]), 0, 1) +

IF ( ISBLANK('SupplierAudit'[ImageUrls.2]), 0, 1) +

IF ( ISBLANK('SupplierAudit'[ImageUrls.3]), 0, 1) +

IF ( ISBLANK('SupplierAudit'[ImageUrls.4]), 0, 1) +

IF ( ISBLANK('SupplierAudit'[ImageUrls.5]), 0, 1) +

IF ( ISBLANK('SupplierAudit'[ImageUrls.6]), 0, 1)

[v-yulgu-msft · Accepted solution]

Hi @Sisko ,

Above formula should work in a calculated column, not in a measure.

Besides, you can unpivot above table, then, new a calculated column to check if URL column is blank, if yes, show 0, otherwise show 1. Then, sum up the new calculated column to get the total value of image URLs.

For more advice, please provide sample data and desired result.

Best regards,

Yuliana Gu