Forum Discussion
Solved
Measure applies to blank, empty rows
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 appear...
- 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) ) 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 🙂 )
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) )
You could try IF(ISBLANK([Kuota za 2021]),
But also, use the DIVIDE function.
Measure: Zmiana % = DIVIDE( [Kwota za 2021] , [Kwota za 2020] -1) )
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 🙂 )- 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!