Forum Discussion

DMSJennifer's avatar
DMSJennifer
Helper I
5 years ago
Solved

Benchmark grouping

Hey,

 

I hope someone can help me with the following problem: I want to make a dashboard with 2 tables: one table with individual data, selected by a slycer. And one table that (automatically) shows the same kind of data, but not with one individual customer, but with an average of multiple customers. Those customers have to be similar to the individual customer so you can show a benchmark.

 

For example: we want to benchmark on Total sales, and select all the customers with similar sales, and then show what the benchmark results are for average cost, average expences, average amount of products bought, etc.

 

I cant quite figure this problem out, so I hope some of you can help me with it!

Thanks in advance!

 

Kind greetings,

Jennifer

Need Help
  • amitchandak's avatar
    amitchandak
    5 years ago

    DMSJennifer , based on what I got, try measure like these for benchmark

     


    calculate(averageX(values(Customer[Customer]), calculate(sum(Table[Amount]))), allselected(customer))

     

    or

     

     

    calculate(averageX(values(Customer[Customer]), calculate(sum(Table[Amount]))), all(customer))

7 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    5 years ago

    DMSJennifer , based on what I got, try measure like these for benchmark

     


    calculate(averageX(values(Customer[Customer]), calculate(sum(Table[Amount]))), allselected(customer))

     

    or

     

     

    calculate(averageX(values(Customer[Customer]), calculate(sum(Table[Amount]))), all(customer))

  • v-xulin-mstf's avatar
    v-xulin-mstf
    Community Support
    5 years ago

    Hi DMSJennifer,

     

    Could you provide sample data and expected output after removing sensitive data?
    Sample data and expected output would help tremendously.

     

    Best Regards,
    Link

     

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

    • DMSJennifer's avatar
      DMSJennifer
      Helper I
      5 years ago

      Hey Link,

      I can't provide sample data, but I can provide Printscreans if that could be helpfull?

      Kind Regards,
      Jennifer

      • v-xulin-mstf's avatar
        v-xulin-mstf
        Community Support
        5 years ago

        Hi DMSJennifer,

         

        Okay!

        Please describe your data structure and expected output.
        Hope to help you as much as possible!

         

        Best Regards,

        Link

         

        Is that the answer you're looking for? If this post helps, then please consider Accept it as the solution. Really appreciate!

         

  • v-xulin-mstf's avatar
    v-xulin-mstf
    Community Support
    5 years ago

    Hi DMSJennifer

     

    Is your issue solved?

    If you still have some question, please don't hesitate to let me known.‌‌

     

    Best Regards,

    Link

     

    Is that the answer you're looking for? If this post helps, then please consider Accept it as the solution. Really appreciate!