Forum Discussion
Filter duplicated bars in the chart
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)))
2 Replies
- amitchandak
Super User
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/1387187#M626
Dynamic Segmentation, Bucketing or Binning: https://youtu.be/CuczXPj0N-kIf this does not help
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data. 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.
