how to get totals in calc groups

[mp390988]

Hi,

I have created a calculation group but the totals that come automatically do not appear to give a total column for the end of each year. It only gives a total after the end of each column header. For example, in the matrix visual below I want a total after dec-24 but before Jan-25.

However, the only time I get totals is when the metric changes from Revenue to IB.

Does anyone know how to get totals appear for each year?

This is my formula for the calculation item:

IF (
    SELECTEDVALUE ( 'IFC'[Metric] ) = "Revenue",
    [Revenue From TradesPlus],
    [IB Paid From IBCommsFinal]
)

Thanks,

[danextian · Accepted solution]

hi @mp390988 

If the goal is to move the measure to a higher level in the hierarchy and a disconnected table/column like 'IFC'[Metric] is already in place, there’s really no need to use a calculation group. The formula can simply be written as a regular measure since it doesn’t apply any reusable logic to other measures — it just returns specific ones directly.

[v-tejrama]

Hi @mp390988 ,

Thank you @danextian  for the response provided!

Has your issue been resolved? If the response provided by the community member addressed your query, could you please confirm? It helps us ensure that the solutions provided are effective and beneficial for everyone.

Thank you for your understanding!

[v-tejrama]

Hi @mp390988 ,

I wanted to follow up and see if you had a chance to review the information shared. If you have any further questions or need additional assistance, feel free to reach out.

Thank you.

[mp390988]

@parry2k - they are used to create custom columns 

[parry2k]

@mp390988, what is the purpose of the calculation group (items)?