Forum Discussion

javif_84's avatar
javif_84
Icon for Helper I rankHelper I
1 year ago
Solved

Average for a characteristic

Hi all   I would like to create a formula from excel in Power BI   Basically independantly from the row sales of the customer it gives the average of sales for the rating of the client considered...
Need Help
  • v-dineshya's avatar
    v-dineshya
    1 year ago

    Hi javif_84 ,

    Could you provide sample data or a PBIX file? This will help us better understand your issue and guide you toward a solution.

     

    Regards,

    Dinesh

Anonymous's avatar
Anonymous
Not applicable
1 year ago

Hi javif_84,

 

Thank you for reaching out to Microsoft Fabric Community Forum.

 

You can calculate the average using the following approach:

AVG = AVERAGEX(FILTER(Sheet2,Sheet2[Rating]IN {"C1","C2","C3","C4"}),Sheet2[Units Sold])

 

  • Use a slicer for the Rating column to allow users to select categories dynamically.
  • Display the result in a Card visual to showcase the average Units Sold for the selected ratings.

If this post helps, then please consider Accepting as solution to help the other members find it more quickly, don't forget to give a "Kudos" – I’d truly appreciate it!


Regards,
Vinay Pabbu

javif_84's avatar
javif_84
Icon for Helper I rankHelper I
1 year ago

Hi

It does not work as you can see the average of a C3 for a field AM/ABM is different to a C3 for another AM/ABM. What I would like is the all C3 have the same average independently of the AM/ABM selected 

 

 

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    Hi javif_84,

     

    Could you provide sample data or a PBIX file? This will help us better understand your issue and guide you toward a solution.

     

    Regards,

    Vinay Pabbu

    • Anonymous's avatar
      Anonymous
      Not applicable
      1 year ago

      Hi javif_84,

       

      May I ask if you have gotten this issue resolved?

      If it is solved, please mark the helpful reply or share your solution and accept it as solution, it will be helpful for other members of the community who have similar problems as yours to solve it faster.

       

      Regards,
      Vinay Pabbu

  • v-dineshya's avatar
    v-dineshya
    Icon for Community Support rankCommunity Support
    1 year ago

    Hi javif_84 ,

    Could you provide sample data or a PBIX file? This will help us better understand your issue and guide you toward a solution.

     

    Regards,

    Dinesh

  • v-dineshya's avatar
    v-dineshya
    Icon for Community Support rankCommunity Support
    1 year ago

    Hi javif_84 ,

    May I ask if you have gotten this issue resolved?

    If it is solved, please mark the helpful reply or share your solution and accept it as solution, it will be helpful for other members of the community who have similar problems as yours to solve it faster.

     

    Regards

    • v-dineshya's avatar
      v-dineshya
      Icon for Community Support rankCommunity Support
      1 year ago

      Hi javif_84 ,

      We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet.In case we do not receive a response, we shall proceed to close this thread. For any further discussions or queries, please initiate a new thread in the Microsoft Fabric Community Forum, where we will be glad to assist you.

      Thank you.