Count how many times a value appears with multiple conditions

[mmoreira7]

Hello,

I am facing this problem and tried all the ways I can to solve it. I read so many info but cant get the result I want.

I want to build a visual or a table based on the info on the table below that shows how many times a "product_code" was selled with another "product_code" based on "process".

To better understand:

Process: like the number id of the sale

Product_code: number id of the product

For example:

I thank in advance to everyone that could help. 

If you need more information please just ask for it. I will be tottaly avaliable.

Thank you.

[Greg_Deckler]

Can you post sample/example data in text (not image) and also post your expected output for that data? 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

[mmoreira7]

Hi Greg,

First of all i want to thank you for your interest in helping me.

I read the article and I think i am doind correctly now.

If you need more information please just ask.

Thank you.

This is my data:

STORE_CODE	PROCESS	SEQ_NUMBER	OPERATION_TYPE	ABS_NUMBER	PRODUCT_CODE
21	75167621	1	1	75167621	688
21	75167621	2	1	75167621	174
21	75167621	3	1	75167621	320
21	75167621	4	1	75167621	606
11	75167603	1	1	75167602	53
5	75167500	1	1	75167499	27
11	75167365	1	1	75167364	68
21	75167299	1	1	75167299	293
21	75167299	2	1	75167299	1580
21	75167299	3	1	75167299	706
21	75167299	4	1	75167299	649
21	75167299	5	1	75167299	583
21	75167299	6	1	75167299	26
21	75167299	7	1	75167409	272
21	75167299	8	1	75167660	1
21	75167299	9	1	75167678	447
21	75167299	10	1	75167695	26270
11	75167272	1	1	75167272	690
11	75167272	2	1	75167272	740
11	75167272	3	1	75167314	272
11	75167272	4	1	75167440	360
11	75167272	5	1	75167552	1
5	75167255	1	1	75167255	255
5	75167255	2	1	75167255	341
5	75167255	3	1	75167255	1458
5	75167255	4	1	75167255	46
5	75167255	5	1	75167509	1
11	75167222	1	1	75167221	26020
11	75167222	2	1	75167221	25919
11	75167222	3	1	75167221	2304
11	75167222	4	1	75167221	1807
3	75167196	1	1	75167196	203

What I want to get?

To know how many times a product code appears with another product code sharing the same process. 

This is the example of the information that i nedd (hand made):

PRODUCT_CODE	1	26	27	46	53	68	174	203	255	272	293	320	341	360	447	583	606	649	688	690	706	740	1458	1580	1807	2304	25919	26020	26270
1	3	1		1					1	2	1		1	1	1	1		1		1	1	1	1	1					1
26	1	1								1	1				1	1		1			1			1					1
27			1
46	1			1					1				1										1
53					1
68						1
174							1					1					1		1
203								1
255	1			1					1				1										1
272	2	1	1							2				1	1	1		1		1	1	1		1					1
293	1	1	1							1					1	1		1			1			1
320							1					1					1		1
341	1			1					1				1										1
360	1									1				1						1		1
447	1	1								1	1				1	1		1			1			1					1
583	1	1								1	1				1	1		1			1			1					1
606							1					1					1		1
649	1	1								1	1				1	1		1			1			1					1
688							1					1					1		1
690	1									1				1						1		1
706	1	1								1	1				1	1		1			1			1					1
740	1									1				1						1		1
1458	1			1					1				1										1
1580	1	1								1	1				1	1		1			1			1					1
1807								1																	1	1	1	1
2304								1																	1	1	1	1
25919								1																	1	1	1	1
26020								1																	1	1	1	1
26270	1	1								1	1				1	1		1			1			1					1

Thank you one more time.

[mmoreira7]

Hi @Greg_Deckler, Did you had the chance to see this? Is in correct format now?

Thank you so much.

[Greg_Deckler]

While not in a grid as you display, a meassure like:

Measure 10 = COUNTX(DISTINCT(Table21[PROCESS]),[PROCESS])

See Table 21, Page 12

[mmoreira7]

Hi @Greg_Deckler.

Thank you so much for your time to help me.

So. I saw the solution that you sugested me. I think I cant get what I need from this measure. 

Lets see:

The measure that you sugested me will tell how many times a product appears in a distinct process. Am i right? This measure tells me that the product_code 1 appears 3 times.

What I need is "how many times the product_code 1 appears with others sharing the same process".

If I explain the final use maybe this could get easier. Our need is to see what products are selled with other products in the same purchase.

For example, I need to know how many times our costumer purchased the product_code 1 with the other codes in the same purchase (process = unique value for purchase ID).

What do you think? Did I missed something in your solution?

Thank you one more time!

[mmoreira7]

Anyone could help me?

@Greg_Deckler did you had the chance to see this?

Thank you.