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.
Greg_Deckler's avatar
Greg_Deckler
Community Champion
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

    My output is supposed to be an actual table, just as I showed in the initial question.

     

    When I create a calculated column (within any of the included tables), I still run into the issue of having some type of aggregation.

     

    • In Products, I can use 'YearlySales', but not 'Employees' in my DIVIDE(...) formula (or even using the '/' operator) without aggregating it first.
    • In Shops, I can't use either 'YearlySales' nor 'Employees' in my DIVIDE(...) formula (or even using the '/' operator) without aggregating them first.
    • In ShopInfo, I can use 'Employees', but not 'YearlySales' in my DIVIDE(...) formula (or even using the '/' operator) without aggregating them first.

    In all cases, whenever I use MAX(...), MIN(...), SUM(...), AVERAGE(...) to aggregate the field that 'needs' aggregation, I don't get the result I need.. 😞