Measure applies to blank, empty rows

[jeyjey344]

Hi,

I created a measure that compares year to year sale.  Right now, there are only 2 main accounts in use (from 100 avaliable in table). When I add my measure to matrix table, all of them appears, even if there are no values (exept from measure that is -100% in that case). Please see screens below, to help you understand my problem. On the 2nd screen i would like to see only accounts with values.

I think, that I need to modyfy my measure, to not apply to empty rows, but I don't have good idea for that.

Measure: Zmiana % = IFERROR(([Kwota za 2021]/[Kwota za 2020] -1), "")

[AllisonKennedy · Accepted solution]

What are you trying to calculate exactly?

You could try IF(ISBLANK([Kuota za 2021]),

But also, use the DIVIDE function.

Measure: Zmiana % = DIVIDE( [Kwota za 2021] , [Kwota za 2020] -1) )

[AllisonKennedy · Accepted solution]

What are you trying to calculate exactly?

You could try IF(ISBLANK([Kuota za 2021]),

But also, use the DIVIDE function.

Measure: Zmiana % = DIVIDE( [Kwota za 2021] , [Kwota za 2020] -1) )

[jeyjey344 · Accepted solution]

Hi @AllisonKennedy , thank you for your reply. I wanted to apply measure only if one of [Kwota za 2021] or [Kwota za 2020] is not empty. But I realized that it will be fine to just check if one of them is empty.

I ended up with measure

Zmiana % = IF(ISBLANK([Kwota za 2020]) = TRUE(), Blank(), DIVIDE( [Kwota za 2021] , [Kwota za 2020] ) -1 )

I was not able to do it before since I was using ISEMPTY instead of ISBLANK.

Final resoult looks like this, and it is correct now (If more accounts comes, it will look more natural 🙂 )

[AllisonKennedy]

Ah, yes, ISEMPTY works on tables, not on columns/single values.

You don't need the =TRUE() in your formula since the IF statement already accounts for TRUE() values and ISBLANK() will return TRUE() or FALSE, but it's working so that's great!