How to work with total, means, std and filter.

[huynq]

Hi everyone, thanks for comming in advance.

I ran into a issue that I need to calculate the normal distribution but seems like means and stds were not calculated correctly
I have this dataset as an example. What I want to do is to bring the 300 to every row and use it to calculate my number. I have date filter too.  

Anyway, thanks for your helps in advance

Hugo.

[huynq]

Hi @mahoneypat  thanks for your reply.

How can I filter the Month too. Ex: I just want to colllect data from Feb - Apr only. Ofcause the running average will change too.

[mahoneypat]

To include/exclude specific months, you can use ALLSELECTED and a month slicer.  To get last three months or other similar calculation, you'll want to set up a Date table in your model with month and month number columns.

Regards,

Pat

[wdx223_Daniel]

Avg All Months = CALCULATE(AVERAGE(Table[Salary]), ALLSELECTED(Table[Month]))

change ALL to ALLSELECTED, if using month slicer

[mahoneypat]

You need to use CALCULATE to remove the filter on the Month column like this

Avg All Months = CALCULATE(AVERAGE(Table[Salary]), ALL(Table[Month]))

Regards,

Pat