The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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)))
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.
@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.
User | Count |
---|---|
11 | |
8 | |
6 | |
6 | |
5 |
User | Count |
---|---|
24 | |
14 | |
13 | |
9 | |
8 |