Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Calculate Month Total with selected Filter date

Hi   I have a dataset as below :   Month    Day of Month    Values   Distinct count of days      Total(Values)      Average= Total(Values)/Distinct count of days 1             1                ...
Need Help
  • v-lili6-msft's avatar
    v-lili6-msft
    7 years ago

    hi, Anonymous

    You could try these three formulas as below:

    Distinct count of days = CALCULATE(DISTINCTCOUNT('Table'[DAY_OF_MONTH]),ALLSELECTED('Table'[DAY_OF_MONTH]))


Total(Values) = CALCULATE(SUM('Table'[Values]),ALLSELECTED('Table'[DAY_OF_MONTH]))


Average = [Total(Values)]/[Distinct count of days]

    Result:

     

    and here is pbix, please try it.

     

     

    Best Regards,

    Lin

     

v-lili6-msft's avatar
v-lili6-msft
Icon for Community Support rankCommunity Support
7 years ago

hi, Anonymous

You could try these three formulas as below:

Distinct count of days = CALCULATE(DISTINCTCOUNT('Table'[DAY_OF_MONTH]),ALLSELECTED('Table'[DAY_OF_MONTH]))


Total(Values) = CALCULATE(SUM('Table'[Values]),ALLSELECTED('Table'[DAY_OF_MONTH]))


Average = [Total(Values)]/[Distinct count of days]

Result:

 

and here is pbix, please try it.

 

 

Best Regards,

Lin

 

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Thanks a lot Lin. :)

 

This Solution worked for me.