Need count of customers group by code and 0-10 days value not equal to zero

[rajanisankar]

Hi All,

I am new to Power BI and trying to solve a problem.

My excel is having 3 columns: Code, Customer, bucket 0-10 days (measure)

Need number of customers which are having values in 0-10 days bucket against to each code.

tried with combinaiton of count and group by but unable to get it.

Thanks in advance.

[rsbin · Accepted solution]

@rajanisankar ,

Pleases try this as a Measure:

NumberofCustomers = CALCULATE( COUNTA(YourTable[Customer] ),
                          FILTER( YourTable, YourTable[0-10 Days] > 0 ))

Then use this Measure in a table visual or other chart visual.

Hope this helps.

Regards,

[rajanisankar]

Thanks much for the quick reply. it is working as expected.