Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Aggregation problem in calculated column

EDIT: Link to PBIX-file: ShopInfo   Hi all!   I could use some help wrapping my head around the following issue:   I have three tables in my model:     They look like:   Now I'...
Need Help
  • Greg_Deckler's avatar
    Greg_Deckler
    6 years ago
    Right, if you use a measure, you will need to use an aggregation, just use MAX if your output is a table visualization.

    If your output that you show is an actual table, you can create a calculated column and not have to use aggregation.
Anonymous's avatar
Anonymous
Not applicable
6 years ago

Link to PBIX-file: ShopInfo 

  • Greg_Deckler's avatar
    Greg_Deckler
    Community Champion
    6 years ago
    Measure = MAX('Products'[YearlySales]) / MAX('ShopInfo'[Employees])
     
    As I stated in my original reply, you need to use a measure and when using a measure, you need to use an aggregation and I indicated that you should likely go with MAX.
     
    PBIX is attached but it is updated to latest version.