Forum Discussion

DMSJennifer's avatar
DMSJennifer
Icon for Helper I rankHelper 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) show...
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))

v-xulin-mstf's avatar
v-xulin-mstf
Icon for Community Support rankCommunity 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!