Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

GROUPBY + ALLEXCEPT functions

Hello, I have this table from which I want to get the average qty per order. 1) I have this measure to help me achieve it. Measure = Var Group_1= GROUPBY( 'Table',        'Table'[Month], ...
Need Help
Tips and Tricks
  • AlexisOlson's avatar
    AlexisOlson
    4 years ago

    I think something simpler might work. Is this what you're after?

    Measure =
VAR Group_1 =
    GROUPBY (
        'Table',
        'Table'[Order],
        "Sum", SUMX ( CURRENTGROUP (), 'Table'[Qté] )
    )
RETURN
    AVERAGEX ( Group_1, [Sum] )

     

jeroendekk's avatar
jeroendekk
Icon for Responsive Resident rankResponsive Resident
4 years ago

Hi Anonymous 
It would help if you can post your sample data in a format that can be copied, so people here can make mock report to check if their proposed solution works.

Best regards,
Jeroen