calculate the total

[MP_123]

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 to show the total amount (static for all points)

i wroth this:

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

but when i added this to the tool tips, it's do filtered by time.

what am i doind wrong? thanks!

[BhaveshPatel]

CALCULATE(…, ALL(Table) ) will remove filters not only from Table but also from its related tables, while ALL(T[Column]) doesn’t have an impact on tables related to Table. As a result, the value of CALCULATE(…, ALL(…, T[C])) is affected only by the slice on T[Column] as slices on other columns have been masked by columns returned from ALL.

[MP_123]

@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]

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

[MP_123]

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]

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]

@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]

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