Products purchased by Same Customer

[schoden]

Hi Community, 

I tried to group customers based on purchasing same TYPE of product or Not.

If customer A buys fruit and machine , it is Mixed  otherwise Non- mixed.

I tried to find previous row value, apply condition of mixed and non- mixed but couldnt achieve what I needed.

Any help will be appreciated.

For the test file: 

https://netlinkgroup-my.sharepoint.com/:u:/g/personal/schoden_netlinkgroup_com_au/EUA7Tf_fbXBNpx54Yx...

[PhilipTreacy · Accepted solution]

Hi @schoden 

Download PBIX with solution

This measure does the trick

Measure = 

VAR _DistinctType = CALCULATE(DISTINCTCOUNT('Table'[Type]), FILTER(ALL('Table'), 'Table'[Customer ] = SELECTEDVALUE('Table'[Customer ])))

RETURN 

IF (_DistinctType > 1, "Mixed", "Not Mixed")

Regards

Phil

[VahidDM · Accepted solution]

Hi @schoden 

Use this code to add a new table:

New Table = SUMMARIZE('Table','Table'[Customer ],"Check",if(CALCULATE(DISTINCTCOUNT('Table'[Type]),ALLEXCEPT('Table','Table'[Customer ]))>1,"Mixed","Not Mixed"))
                  

Output:

If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
LinkedIn: www.linkedin.com/in/vahid-dm/

[schoden]

Thanks for saving my day 😄

[PhilipTreacy · Accepted solution]

Hi @schoden 

Download PBIX with solution

This measure does the trick

Measure = 

VAR _DistinctType = CALCULATE(DISTINCTCOUNT('Table'[Type]), FILTER(ALL('Table'), 'Table'[Customer ] = SELECTEDVALUE('Table'[Customer ])))

RETURN 

IF (_DistinctType > 1, "Mixed", "Not Mixed")

Regards

Phil

[schoden]

Thanks for sharing the knowledge 😄