Forum Discussion
Microsoft Employeecalculate 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 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!
7 Replies
- BhaveshPatel
Super User
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_123BhaveshPatel 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.
