Ignoring user selection in one field

[G3S]

Hi,

in the app, I have multiple fields as filters. 

fields 'Version' and  'Carrier' will be selected. I need to keep field 'Version' (and selections from other fields) & ignore selection in 'Carrier' completely to calculate TotalTEU. Please help to calculate TotalTEU.

POL	Carrier	Version	CntrTEU	TotalTEU
Naples	AAA	2020	200	300
Naples	BBB	2020	100	300

calculating Cntr TEU with this expression: 

sum(aggr(([CntrTEU]),[CntrSeal]))

thank you

[Taoufiq_Zarra]

Hi,

for example to ignore selection in 'Carrier' for sum(TotalTEU), the script :

=sum({<Carrier=>}[TotalTEU])

output :

[G3S]

Thank you @Taoufiq_Zarra 

apologies, I should have mentioned that the table is the required output.  these are the data fields:

• POL
• Carrier
• Version
• CntrTEU

I am looking for a solution to calculate the TotalTEU (using CntrTEU field). 

[Taoufiq_Zarra]

can you share the output from the initial table ?

[G3S]

@Taoufiq_Zarra 

POL	Carrier	Version	CntrTEU	TotalTEU
Naples	AAA	2020	200	200
Naples	BBB	2020	100	100

need for TotalTEU to show as 300 in both lines.

[Taoufiq_Zarra]

@G3S  if I understood correclty :

Dimension: POL, Carrier, Version, CntrTEU

Measure :

=sum({<Carrier=>} total [TotalTEU])

or :

=sum({<Carrier=>} total<POL,Version> [TotalTEU]) if it depend to POL,Version

output of both in this case :

[G3S]

@Taoufiq_Zarra 

TotalTEU to be calculated at the front end. It is not a data field. 

I think correct response for your request for initial table is:

POL	Carrier	Version	CntrTEU
Naples	AAA	2020	200
Naples	BBB	2020	100

[Taoufiq_Zarra]

@G3S  Ok 😀

Dimension: POL, Carrier, Version

Measure :

=sum({<Carrier=>} total [CntrTEU])

or :

=sum({<Carrier=>} total<POL,Version> [CntrTEU]) if it depend to POL,Version

[G3S]

👍 @Taoufiq_Zarra 

it works when I have not made a selection in the 'Carrier' field.  

but when a selection is made in  'Carrier' field,  'TotalTEU' shows the same as the CntrTEU.

POL	Carrier	Version	CntrTEU	TotalTEU
Naples	AAA	2020	200	200

How to get it to show 300 which is the sum of CntrTEU for POL, Version even when a selection is made in 'Carrier'?

(apologies, this is first time posting to a forum)

[Taoufiq_Zarra]

I didn't quite get it,
here's what I find if I select Carrier no change 300 ?