Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Multi-level aggregation using DAX

Hello,   I've encountered a problem when writing a DAX measure.   My design: - A fact table - A Date dimension (granularity: day) - A Time dimension (it has Hour integers and Minute integers -...
Need Help
Tutorial Requests
  • v-cherch-msft's avatar
    v-cherch-msft
    7 years ago

    Hi Anonymous

     

    You may try below measure:

    Test =
SUMX (
    SUMMARIZE (
        Table1,
        Table1[Dim Customer],
        Table1[Dim Date],
        Table1[Dim Time-Hour]
    ),
    SUM ( Table1[Value] ) / COUNT ( Table1[Dim Time-Hour] )
)

     

    Regards,

    Cherie

v-cherch-msft's avatar
v-cherch-msft
Microsoft Employee
7 years ago

Hi Anonymous

 

You may try below measure:

Test =
SUMX (
    SUMMARIZE (
        Table1,
        Table1[Dim Customer],
        Table1[Dim Date],
        Table1[Dim Time-Hour]
    ),
    SUM ( Table1[Value] ) / COUNT ( Table1[Dim Time-Hour] )
)

 

Regards,

Cherie