Column Totals when using count if

[DMG]

Hi,

I'm using the following formula

if(count({<APP_PRIO={'High'},[Death Date]={'NA'}>}[DOMAIN_ID])>0,1,0)

This counts domain id's APP_PRIO is high and Death Date is NA, placing 1 in the cell if the value is >0 and 0 otherwise.

This is in a measure, but the total columns for the measure dont add the values of 1 or 0, i assume maybe they are being treated as text values rather than numbers, is there a way to fix this ?

[GaryGiles · Accepted solution]

In the properties panel for the Chart measure, look for the "Totals function" option and choice sum from the drop-down.