Filtering table and summing the the number of times it occurs

[Anonymous]

Hi All,

Im currently working on a project to measure our influence/impact on social media currently. 

What I am trying to achieve is a DAX formula that will:

a) filter the sentiment column,1 through 5. So I looking at 5 DAX formulas altogether

b) Sum the number of occurances it had occurred, using the occurances field. 

Some of the data:

What I have achieved so far is but its showing as an error.

M_Count_Negative = SUMX(FILTER(sentimental_value, sentimental_value[Sentiment]=5),sentimental_value[Occurances])

Regards

[Anonymous]

Hi Amit,

I had a look at the data type of each column and the Sentiment value was not given the correct datatype. It was a text datatype and NOT a whole number. I had now changed this and it is working correctly.

Thank you

[amitchandak · Accepted solution]

@Anonymous , The formula seems correct,what is the result you are getting and what is expected 

Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.