Forum Discussion

Mjolnir's avatar
Mjolnir
Icon for Helper I rankHelper I
2 years ago
Solved

Measure: How do I make it ignore certain values in visual content?

Hi,   Want to create a measure that sums the values if the account number starts with a number greater than 2.   All accounts with values equal to blank, empty or zero should be ignored; all acc...
  • Mjolnir's avatar
    Mjolnir
    2 years ago

    Thanks for your response. I changed the SUM to SUMX and it solved the problem.

Mjolnir's avatar
Mjolnir
Icon for Helper I rankHelper I
2 years ago

Thanks for your response. I changed the SUM to SUMX and it solved the problem.

Mjolnir's avatar
Mjolnir
Icon for Helper I rankHelper I
2 years ago

In addition to my comment, sum and sumx alone seem to retrieve and only show accounts with existing values. The issue seemed to be caused by FORMAT, so removed the FORMAT in the function and all blanks disappeared.