Basket Analysis

Bryanna — Thu, 11 May 2023 21:48:32 GMT

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:

Re: Basket Analysis

v-yueyunzh-msft — Mon, 15 May 2023 05:34:46 GMT

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

topic Re: Basket Analysis in DAX Commands and Tips

Basket Analysis

Re: Basket Analysis