Forum Discussion
ClaireLin
6 years agoFrequent Visitor
Same column sum different value with average total
Hi, 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. The total views of "day" should b...
amitchandak
Super User
6 years agoClaireLin , not very clear to me, need some sample data
But try like
Avg Views=
avergageX(summarize('Dimension', 'Dimension'[dimension],"_1" [views]),[_1])