Forum Discussion

PaulTran's avatar
PaulTran
Regular Visitor
2 years ago
Solved

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...
  • amitchandak's avatar
    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])