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))

amitchandak's avatar
amitchandak
Icon for Super User rankSuper 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))