column totals

[SLima]

I created this measure to create and calculate a column totals.
Does not obey filters

TTotal Tipo Serviço =

VAR vTotalTipoServ =

[Total de Vendas]

VAR vTotalSelecionado =

CALCULATE (

[Venda Total Produto],

INTERSECT (

VALUES ( fVendasProduto[Prod Ou Serv] ),

VALUES ( 'dTotTipoServ'[Prod Ou Serv] )

)

)

RETURN

IF (

HASONEVALUE ( 'dTotTipoServ'[Prod Ou Serv] ),

SWITCH (

VALUES ( 'dTotTipoServ'[Prod Ou Serv] ),

"Total", vTotalTipoServ,

vTotalSelecionado

)

)

[amitchandak]

@SLima ,Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.