Forum Discussion

kewaynes333's avatar
kewaynes333
Helper I
4 years ago
Solved

Average Agg Issue

Hi,    I'm trying to get an average of daily transactions at 3 levels and am not sure how to do it.   Here is the sample data   What I want to happen is to the average daily transactions ...
Need Help
  • Jihwan_Kim's avatar
    Jihwan_Kim
    4 years ago

    Hi,

    I am not sure whether I understood your question correctly, but please check the below picture and the attached pbix file.

     

     

    Expected measure = 
AVERAGEX (
    VALUES ( 'Product'[Caegory] ),
    CALCULATE ( SUM ( Sales[Quantity] ) )
)
Jihwan_Kim's avatar
Jihwan_Kim
Super User
4 years ago

Hi,

I am not sure whether I understood your question correctly, but please check the below picture and the attached pbix file.

 

 

Expected measure = 
AVERAGEX (
    VALUES ( 'Product'[Caegory] ),
    CALCULATE ( SUM ( Sales[Quantity] ) )
)