#Mostrar 0 instead of Blank in the visual

[Syndicate_Admin]

Dear Champions,

I am faced with a very irritating problem.

I'm using a simple measure to get the sum of values if a condition is met, something like:

Valueswithflag = Calculate(SUM(MyTable[ColumnName]),MyTableFlag = 'Y')

Now the problem is when the flag is not set to Y, it is returned blank and when I try to replace it with ) following all the solutions such as:

1) Add +0 to the measure

2) Application of ISBLANK()

3) Use of COALESCE

gives an error of images exceeded in my visual

[MFelix · Accepted solution]

Hi @Chamansharma145 ,

Try the following:

Valueswithflag = IF(SELECTEDVALUE(MyTableFlag <> 'Y'), 0,Calculate(SUM(MyTable[ColumnName]),MyTableFlag = 'Y'))