Forum Discussion

bdehning's avatar
bdehning
Post Prodigy
4 years ago

Replace no value with a zero in Conditional Column

I have a Conditonal Column   Litigated Text   If Litigated equals "True" Outout  Litigated Else 'Not LItigated"   If there are no rows in a given year, I want to show a zero and not a blank in...
Need Help
bdehning's avatar
bdehning
Post Prodigy
4 years ago

I do use a measure to count the Litigated and Not Litigated and probably where I need to introduce a 0.

 

The measure is Count = CALCULATE(COUNT([Total Gross Incurred]))

Syk's avatar
Syk
Resident Rockstar
4 years ago

Yes! Just add a +0 on the measure

Count = CALCULATE(COUNT([Total Gross Incurred])) + 0