Countifs then average in DAX

[Acidkill]

Hi everyone,

I'm currently transitioning to PowerBi and is in a bit of mess with converting excel formulas to DAX.
I am tryin to get the number times the store_number has appeared each day the get the average number of times it appeared for the month or week.

thank you in advance as this site as been my lifeline since I joined

here is my data sample:

Ticket_Number FullDate Issue_Store_Number 2001583339 12/1/18 14167 2001583380 12/1/18 13586 2001583383 12/1/18 366 2001583429 12/1/18 214 2001583473 12/1/18 15777 2001583492 12/1/18 19801 2001583513 12/1/18 15311 2001583514 12/1/18 9117 2001583628 12/1/18 10310 2001583662 12/1/18 12887 2001583684 12/1/18 17994 2001583742 12/1/18 76 2001583759 12/1/18 13835 2001583765 12/1/18 2846 2001583782 12/1/18 13088 2001583829 12/1/18 1182 2001583831 12/1/18 8899 2001583832 12/1/18 9260 <colgroup><col width="107" style="width: 80pt; mso-width-source: userset; mso-width-alt: 3913;"> <col width="59" style="width: 44pt; mso-width-source: userset; mso-width-alt: 2157;"> <col width="147" style="width: 110pt; mso-width-source: userset; mso-width-alt: 5376;"> <tbody> </tbody>

<colgroup><col width="107" style="width: 80pt; mso-width-source: userset; mso-width-alt: 3913;"><tbody>
</tbody>

 

[Hashiru]

Hi AcidKill,

What is your definition of Average Per month and Per Week. Can you provide the excel formulas you were using?

 

[Acidkill]

Hi Hashiru,

Thank you for replying.

it's average number of time the store number has appeared in a given time period like a week or a month. I first created pivot table for the data, then just did the below--Ticket count monthly average.

hope that helps

	Feb
Total Number of Stores calling ERC	13307
Total Number of New Stores Calling (Open < 1 year)	617
Total Number of Stores Calling at 40% more (Exception)	3404
Total Number of New Stores calling at 40% more than avg.*	255
Percent of Exception Stores Calling ERC(out of all stores)	25.58%
Ticket Count Monthly Average	4.24
Exception threshold	5.93

<colgroup><col width="398" style="width: 299pt; mso-width-source: userset; mso-width-alt: 14555;"> <col width="158" style="width: 119pt; mso-width-source: userset; mso-width-alt: 5778;"> <tbody> </tbody>