Forum Discussion
Solved
SUMX functions with ISBLANK?
Good evening all, I am trying to learn DAX, but have now an easy problem wherefor i can't fond the solution. I made below measure for a card visual. Measure punten = sumx( DISTINCT...
hi LogiFons
you can wrap the expression with the coalesce function, e.g :
Some Total = Coalesce( SUMX( SomeTable,SomeTable[SomeColumn] ), 0 )or you can add a 0 to the expression e.g :Sum Total = SUMX( SomeTable,SomeTable[SomeColumn] ) + 0so with a condition it would look lie :Some Total 2 = Coalesce( SUMX( FILTER( SomeTable, SomeTable[AnotherColumn] = "2" ), SomeTable[SomeColumn]), 0 )
rubinboer
Resolver II
Resolver IIhi LogiFons
you can wrap the expression with the coalesce function, e.g :
Some Total = Coalesce( SUMX( SomeTable,SomeTable[SomeColumn] ), 0 )
or you can add a 0 to the expression e.g :
Sum Total = SUMX( SomeTable,SomeTable[SomeColumn] ) + 0
so with a condition it would look lie :
Some Total 2 = Coalesce( SUMX( FILTER( SomeTable, SomeTable[AnotherColumn] = "2" ), SomeTable[SomeColumn]), 0 )
Hi Rubinboer,
Thank you for your fast response.
I had already tried to add the +0.
But i added this before the ).
This doesn't wordt.
The +0 after the ) does work!
Thank you for this solution!
Enjoy your evening.