Forum Discussion

ckhoo2007's avatar
ckhoo2007
Icon for Helper I rankHelper I
5 years ago
Solved

AverageX with Date Slicer

Hi All, I have a sample data as follow, Date Client Average Sales Transactions 4/5/2021 A 811.53 5 3/5/2021 A 705.08 9 29/4/2021 B 701.98 1 3/5/2021 C 581.45 2 7/5/...
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    HI ckhoo2007,

    You can try to use the following measure formula if helps:

    Masure =
DIVIDE (
    AVERAGEX (
        SUMMARIZE (
            ALLSELECTED ( Sales ),
            [Date],
            [Client],
            "Rate", Sales[Average Sales] * Sales[Transactions]
        ),
        [Rate]
    ),
    SUM ( Sales[Transactions] )
)

    Regards,

    Xiaoxin Sheng

Anonymous's avatar
Anonymous
Not applicable
5 years ago

HI ckhoo2007,

You can try to use the following measure formula if helps:

Masure =
DIVIDE (
    AVERAGEX (
        SUMMARIZE (
            ALLSELECTED ( Sales ),
            [Date],
            [Client],
            "Rate", Sales[Average Sales] * Sales[Transactions]
        ),
        [Rate]
    ),
    SUM ( Sales[Transactions] )
)

Regards,

Xiaoxin Sheng

ckhoo2007's avatar
ckhoo2007
Icon for Helper I rankHelper I
5 years ago

Thanks XiaoXin!