Visuals Not Grouping

[Kamis11]

Hi, I'm trying to display the company name and the SUM of a specific column combined but it just doesn't seem to group the company name.

Example of my desired output:

Company Name	like_num
AAPL	1,500,000
AMZN	2,500,000
etc..	etc...
Total	8,253,814

This is what's happening:

My data model

my dataset is from:

https://www.kaggle.com/omermetinn/tweets-about-the-top-companies-from-2015-to-2020

What I've tried:

1. Checked my visual options, everything is fine.

2. DAX groupby function

3. DAX Summarizecolumn function

Any suggestions are appreciated. 

 

 

[v-yanjiang-msft · Accepted solution]

Hi @Kamis11 ,

I download your dataset, but in the company table, there is only AAPL in the column ticker_symbol, and the relationship is many to many, I also get an unexpected result.

In my understand, one tweet ID should has one line of information in both company_tweet and tweet table, but it’s too many to verify, I guess there’s something wrong in the data source. I create a sample, let the summarization of the like_num be sum, and put the two columns in the visual, it works fine, so please check your data source again.

Best Regards,
Community Support Team _ kalyj

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[AlexisOlson]

I think the simplest solution would be to merge Company_Tweet into Tweet so that you don't have an intermediate table preventing Company from filtering Tweet.