Forum Discussion

Bryanna's avatar
Bryanna
Icon for Helper II rankHelper II
3 years ago
Solved

Basket Analysis

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 ...
  • v-yueyunzh-msft's avatar
    v-yueyunzh-msft
    3 years ago

    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

     

     

v-yueyunzh-msft's avatar
v-yueyunzh-msft
Icon for Community Support rankCommunity Support
3 years ago

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