Countif complications in power bi

[Sankzpower]

Hi guys

Here is my attached Sample file. My table contains customername, split by dates and values for each day. What I would like it to show is that count number of days (i.e) a simple count(date) and average the total value by customer where its greater than 0. Then count the number of days where the value is greater than the average. 

I have completed this task in excel (this is also shown in the attached file and below ) but doing in power bi is a challenge for me. Can someone please help me?

Customer	Countdays	Average total>0	Countif > than average	Result - Data Coverage
A	92	43.83	5	5%
B	99	380.77	15	15%
C	240	755.92	83	35%
D	57	802.67	19	33%

Thanks

[az38 · Accepted solution]

Hi @Sankzpower 

dont understand how do you calculate Result - Data Coverage, but for other columns try measures:

Average total > 0 = calculate(AVERAGE(Table1[value]);allexcept(Table1;Table1[customer.name]);Table1[value]>0)

and

Countif > than average = calculate(countrows(FILTER(Table1;Table1[value]>[Average total > 0])))

do not hesitate to give a kudo to useful posts and mark solutions as solution

LinkedIn

[Sankzpower]

Thanks @az38 . It did not work exactly to what I needed but your code gave me another idea which had worked. 

Cheers.