Forum Discussion
PaulTran
2 years agoRegular Visitor
Difference Between SUM a column by aggregate function and SUM by a DAX measure
I have 4 Table, Sales, Product, Store & Ranking with the relationship as below: - Product 1:* Sales - Product 1:* Ranking - Store 1:* Sales - Store 1:* Store When I use the aggregate function, t...
- 2 years ago
PaulTran , Both Rank and Sales should be Measure. You can not have ungrouped data from rank
Sum(Sales[Sales])
Max(Rank(Rank])
amitchandak
Super User
2 years agoPaulTran , Both Rank and Sales should be Measure. You can not have ungrouped data from rank
Sum(Sales[Sales])
Max(Rank(Rank])