Basket Analysis

[Bryanna]

I am trying to create a basket analysis to relate items that usally are ordered together. I am still trying to understand what these formulas even mean but was wondering why would items would show a confidence of over 100%? Did i do something wrong in my formulas that could be throwing this off?

Below are my columns:

 

[v-yueyunzh-msft · Accepted solution]

Hi , @Bryanna 

According to your screenshot , the dax code seems to be all calcualted columns .

And the last screenshot ,you may put them in a visual .You're confused as to why [Confidence Item2->Basket] is greater than 100%.

For placing the field in Absolute Want, it means that you are currently filtering based on the previous dimensions, and you can go to your table to check whether the [Confidence Item2->Basket] calculation is correct.

Second, you need to check whether the aggregation criteria you selected in the object you placed are what you want:

Thank you for your time and sharing, and thank you for your support and understanding of PowerBI! 

Best Regards,

Aniya Zhang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly