Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

averages

Dear Community, I need to calculate the average for three specific product (#1,#2,#3) costs, on a daily basis. Then that average should appear as "product 5". I don't know what should be the proper ...
  • CNENFRNL's avatar
    CNENFRNL
    5 years ago

    Hi, Anonymous , a simple measure + matrix viz do the trick with ease

    AVG 123 = 
AVERAGEX (
    FILTER ( DISTINCT ( 'Table'[Product] ), 'Table'[Product] IN { 1, 2, 3 } ),
    CALCULATE ( SUM ( 'Table'[Cost] ) )
)

CNENFRNL's avatar
CNENFRNL
Icon for Community Champion rankCommunity Champion
5 years ago

Hi, Anonymous , a simple measure + matrix viz do the trick with ease

AVG 123 = 
AVERAGEX (
    FILTER ( DISTINCT ( 'Table'[Product] ), 'Table'[Product] IN { 1, 2, 3 } ),
    CALCULATE ( SUM ( 'Table'[Cost] ) )
)