Forum Discussion

Andrew_na_lang's avatar
4 years ago
Solved

Average according to the table visual

Hi Fam,

I would like to get the average of the spending of all customers in the table visual below. The average spend column in the visual is a calculated column in the customers table where everything on the visual is pulled up from. Furthermore, I have buttons where I filter the table which is from a different table ( items table ) that has a one-to-many relationship with the customers table

Actual goal: 

A card visual that shows the average spending of all customers, just like the average_item_count below.

 

 Please help. 

  • Hi Andrew_na_lang 

    I did a local test,here are my visualization screenshots,I will put my pbix file  download url  at the bottom you can download it

     

     

     

    demotest.pbix

    Best Regards,

    Community Support Team _Isabella

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

2 Replies

  • isabella's avatar
    isabella
    Icon for Microsoft Employee rankMicrosoft Employee

    Hi Andrew_na_lang 

    I did a local test,here are my visualization screenshots,I will put my pbix file  download url  at the bottom you can download it

     

     

     

    demotest.pbix

    Best Regards,

    Community Support Team _Isabella

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