Same column sum different value with average total

Question

Hi,&nbsp;I build a database in PowerBI. The structure is as below. The data of views for "day" and "insightTraficSourceType_day" are duplicate but not other data.&nbsp;The total views of "day" should be the same as total views of "insightTraficSourceType_day". Now I use this query:views =CALCULATE(SUM('youtube_insight'[field.views] ),FILTER('Dimension', 'Dimension'[dimension] = "day" || 'Dimension'[dimension] = "insightTrafficSourceType_day"))&nbsp;With this query, I can get all data correctly, but not total views. I hope the total views can still be 21.Could anyone please advise how I can get each sum up correctly and also the total?&nbsp;dimension&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; viewsday &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 21insightTrafficSourceType_day&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 21-----------------------------------------------Total&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 42&nbsp;

amitchandak · Answer

ClaireLin , not very clear to me, need some sample data
But try like
Avg Views= avergageX(summarize('Dimension', 'Dimension'[dimension],"_1" [views]),[_1])

anonymous · Answer

Hi&nbsp;ClaireLin,
I'd like to suggest you take look at following links about different filter levels and measure total calculations:
Clever Hierarchy Handling in DAX&nbsp;
 Measure Totals, The Final Word&nbsp;
Regards,
Xiaoxin Sheng

Forum Discussion

Same column sum different value with average total

2 Replies

Related content

Weekly Average

Matrix Average Column

Average and Moving Average

Average column

Accumulated average