Filter duplicated bars in the chart

[Amanda_Araujo]

I'm using a measure to create a basket analysis ranking and my problem is: the chart shows the same result twice, just by changing the order of products. Someone have any idea how can I filter it?

Here the code:

Ambos produtos = 
VAR InitialPurchase = VALUES(WooCommerce[CPF ANONIMO NEW])
VAR ComparisonPurchase = CALCULATETABLE(VALUES(WooCommerce[CPF ANONIMO NEW]), ALL('SKUs (2)'),
	TREATAS(VALUES('Comparação'[ID Produto (Woocommerce)]), WooCommerce[Id Produto]))

RETURN
IF ('@@@MEDIDASWOW'[@] = TRUE(),
	BLANK(),
		COUNTROWS(INTERSECT(InitialPurchase, ComparisonPurchase)))

[Amanda_Araujo]

Hi! Thanks for your quick answer!

Here is the chart! The problem is: first bar shows A+B, second bar shows B+A, and so on. All bars are duplicated, just the order is different. Sadly, I can't share the data right now.

[amitchandak]

@Amanda_Araujo , Can you share what you are trying to do?

Refer the bucking I have done here

Power BI- Power BI- TOPN with Others- https://youtu.be/I_TY4hVlzAE

or

Dynamic Segmentation Bucketing Binning
https://community.powerbi.com/t5/Quick-Measures-Gallery/Dynamic-Segmentation-Bucketing-Binning/m-p/1...

Dynamic Segmentation, Bucketing or Binning: https://youtu.be/CuczXPj0N-k

If this does not help
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.