How to get region totals

[paulo_costa_ifp]

I have the following chart:

For example, CABEDELO belongs to MESOREGIAO='ZONA DA MATA PARAIBANA' and MICROREGIAO='JOAO PESSOA'. I would like to get totals for the corresponding MESOREGIAO and MICROREGIAO.  The expressions run fine only when I select a MESOREGIAO or MICROREGIAO. Here are the expressions:

SUM(total {<MESOREGIAO={'$(=MESOREGIAO)'},MICROREGIAO=,MUNICIPIO=>}[VALOR PAGTO])

SUM(total {<MICROREGIAO={'$(=MICROREGIAO)'},MESOREGIAO=,MUNICIPIO=>}[VALOR PAGTO])

How can I build these expressions without the need to filter these metadata?

Regards,

Paulo

[Anil_Babu_Samineni]

Do you mean this?

SUM(TOTAL {<MICROREGIAO={'ZONA DA MATA PARAIBANA', 'JOAO PESSOA'},MUNICIPIO=>}[VALOR PAGTO])

[paulo_costa_ifp]

No, Anil.

I would like to build the expression without the need to fix a constant for MICROREGIAO, MESOREGIAO. Based on MUNICIPIO , it would consider totals only for the  corresponding MESOREGIAO and MICROREGIAO, in separate columns.

Do you understand what I mean?

Regards,

Paulo

[Anil_Babu_Samineni]

But, Field = Field ??? What you are going to try here? My assumption is this?

SUM(TOTAL {<MICROREGIAO={"=CABEDELO = MICROREGIAO"},MUNICIPIO=>}[VALOR PAGTO])

[paulo_costa_ifp]

My expression is wrong, I know. As MUNICIPIO appears in one line, how could I know (dinamically) the total for the corresponding MICROREGIAO and MESOREGIAO (two new columns).

Do you understand me?

[Anil_Babu_Samineni · Accepted solution]

Extremely Sorry !!! Not really understand still. My luck is

SUM(TOTAL <MESOREGIAO> {<MUNICIPIO=>}[VALOR PAGTO])