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

BhaveshPatel thank you but i don't understand your answer.

i want it to keep the other slicers of the report, i just want it to ignore the filter Time (the Chart Axis) so it won't calculate to each time period, but the sum of all.

and then, to add it as a tool tip

 

 

thanks!

BhaveshPatel's avatar
BhaveshPatel
Icon for Super User rankSuper User
9 years ago

You can use ALLEXCEPT(Query1[Time]). This will ignore the filters on the Time column.

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

    actually it doesn't work. All(time) it's the right way.

    the result is as it should be when i slice on the time, but when i add it to the chart with the time on the axis it doesn't work.

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

      Hi MP_123,

      Slicer is used to filter rows in table. When you create a slicer, and connect it to the chart. The slicer will filter the whole chart, rather than part of it.

      Best Regards,
      Angelia

      • 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!