I cannot make a sum for a measure i created

[andreea_e]

Hi all,

I want to make a report and see from a number of accounts that I have for how many I don't have contacts. I uploaded the excel file and I made a measure: DistBlank = IF('Submission Form'[Cnt_cntry_m]=BLANK(),1,0); so where it's blank put 1.

I want at the end, in the total, to see the sum for all that "1" I have and I don't know how to do this.

Right now it looks like this:

Can anyone help me with this, please?

Thanks,

Andreea 

[gooranga1]

Hi 

Is that formula a measure or a calculated column? IF it's a calculated column you could make a measure by summing the calculated column.

[andreea_e]

Hi,

It's a measure.

I tried to use a matrix/matrix preview visualization with my measure in the value but I got the same results. 

[v-yuezhe-msft]

@andreea_e,

Is Cnt_cntry_m  a measure in your table(Submission Form)? If so, I assume that you have a Account field in your table, please create a new measure using the  DAX below and check if it returns your desired result.

Measure  = IF(COUNTROWS(VALUES('Submission Form'[Account]))=1,[Cnt_cntry_m],SUMX(VALUES('Submission Form'[Account]),[Cnt_cntry_m]))

However, if Cnt_cntry_m is a column of your table(Submission Form), create a calculated column instead of measure using the DAX below.

DistBlank = IF('Submission Form'[Cnt_cntry_m]=BLANK(),1,0)


If the above steps don't help, please share sample data of your table so that we can provide you appropriate DAX .

Regards,