Forum Discussion

MP_123's avatar
MP_123
Icon for Microsoft Employee rankMicrosoft Employee
9 years ago

calculate the total

hi, i have this chart:     i want to add a calulcate measure the calculate the  total clicks (values in line)  i mean, in the graph the total is divided by the time, i want to add tool tip...
Need Help
MP_123's avatar
MP_123
Icon for Microsoft Employee rankMicrosoft Employee
9 years ago

v-huizhn-msft

thanks!

 

how do you suggest to add this calulcated measure to the chare, and to show the constant value of clicks? regardless the  time?

 

thanks!

v-huizhn-msft's avatar
v-huizhn-msft
Icon for Microsoft Employee rankMicrosoft Employee
9 years ago

Hi MP_123，

The value in line chart are 12am-5am, 5am-8am, 8am-11am and so on, right? If it is, you should use ALLEXCEPT posted by BhaveshPatel . You’d better create a measure using the following formula.

Total Positive Clicks = calculate(sum(Query1[CardPositiveClicks]),ALLEXCEPT(Query,Query1[Time]))

Create a slicer including Time, when you select one value in Time column, it will display the value bar and line chart.

Thanks,
Angelia