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

      • 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