topic Re: How to work with total, means, std and filter. in DAX Commands and Tips

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

huynq — Fri, 13 Nov 2020 03:18:51 GMT

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.

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

mahoneypat — Fri, 13 Nov 2020 03:25:07 GMT

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

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

huynq — Fri, 13 Nov 2020 04:00:05 GMT

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.

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

wdx223_Daniel — Fri, 13 Nov 2020 07:43:37 GMT

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

change ALL to ALLSELECTED, if using month slicer

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

mahoneypat — Fri, 13 Nov 2020 14:18:38 GMT

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