Calculate Count based on sum not equal to 0

[Anonymous]

Hi PB buddy,

I would like to have a measure as such result, would anyone help, thanks

count column A where sum of column B is not 0, the outcome should be 2

Many thanks

[Anonymous]

Hi @Anonymous  ,

Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

Cheers, 
Rob

[Anonymous]

Hi @Anonymous , thanks for your reply, pardon English is not my primary language, I've already searched previous post but can't get a right answer, I've made my question as simple as possible as well. 

[Anonymous]

Hi @Anonymous  ,

No problem.

1. Please share sample data via copy/paste (no picture) or share .pbix file.

2. Please share what is your expected result from sample data.

Cheers,

Rob

[Anonymous]

Thanks @Anonymous 

1. Please find the sample data below

Customer	Amount	Code
A0001	100	01
A0001	-100	01
A0002	100	01
A0002	100	01
A0002	0	02
A0002	0	02
A0003	100	01
A0003	100	01
A0003	200	02
A0003	200	02
A0004	200	02
A0004	200	02

2. now I would like 2 measures which
measure 1 = count no. of customer where code = "01" and sum of amount <> 0
desired result = 2 (A0002, A0003)
measure 2 = count no. of customer where (code = "01" and sum of amount <> 0) and (code = "02" and sum of amount <> 0)
desired result = 1 (A0003)

Many thanks in advance

Simon

[Ashish_Mathur · Accepted solution]

Hi,

These measures work

Measure = COUNTROWS(FILTER(SUMMARIZE(VALUES(Data[Customer]),Data[Customer],"ABCD",CALCULATE([Total],Data[Code]=1)),[ABCD]<>0))

Measure 2 = COUNTROWS(FILTER(SUMMARIZE(VALUES(Data[Customer]),Data[Customer],"ABCD",CALCULATE([Total],Data[Code]=1),"EFGH",CALCULATE([Total],Data[Code]=2)),[ABCD]<>0&&[EFGH]<>0))

Hope this helps.

[Anonymous]

Great thanks bro! It's help a lot!

[Ashish_Mathur]

You are welcome.