Forum Discussion

siva3012's avatar
siva3012
Icon for Helper II rankHelper II
8 years ago
Solved

Create new measure to get Average

Hi, I have a table which contains Date, CustomerName, Price, month, & weekday.   I have created measure using the DAX, Day 1 = CALCULATE(sum(Actual[Price]),FILTER('Actual','Actual'[Day]=1)) simila...
Need Help
  • v-yulgu-msft's avatar
    v-yulgu-msft
    8 years ago

    Hi siva3012,

     

    Create an extra measure like:

    Count month selected = DISTINCTCOUNT(Actual[Month])

    Modify the measure for Day 1 as below:

    Day 1 = CALCULATE(sum(Actual[Price]),FILTER('Actual','Actual'[Day]=1))/[Count month selected]

    Result.

     

    Best regards,
    Yuliana Gu

v-yulgu-msft's avatar
v-yulgu-msft
Icon for Microsoft Employee rankMicrosoft Employee
8 years ago

Hi siva3012,

 

Create an extra measure like:

Count month selected = DISTINCTCOUNT(Actual[Month])

Modify the measure for Day 1 as below:

Day 1 = CALCULATE(sum(Actual[Price]),FILTER('Actual','Actual'[Day]=1))/[Count month selected]

Result.

 

Best regards,
Yuliana Gu

siva3012's avatar
siva3012
Icon for Helper II rankHelper II
8 years ago

v-yulgu-msft : Is it possible to draw an average line for those data which is shown in the graph ? Like this