Total even if filtered

[Balhemkan]

Hello Team, 

I have two tables

Table a

Column

A

B

C

Table B

ColumnA  sales

A              10

B               20

C               50

I am using Table A column in slicer

• My scenario is if only C is filtered then show only 50 else show 30 which is sum of A + B

I wrote dax for this but if we select A in slicer then it is showing only 10 instead of 30

When I select B in slicer then it is showing 20 instead of 30.

Could you help me with dax like even if we select A Or B it should show 30 only not specific values under it. 

Kindly help me

[amitchandak · Accepted solution]

@Balhemkan ,

I such a case do not join these two tables

create a measure like

measure =

if("C" in values(Tablea[Column]), calculate(Sum(Tableb[Sales]),filter( Tableb, Tableb[ColumnA] = "C")) , calculate(Sum(Tableb[Sales]),filter( Tableb, Tableb[ColumnA] <> "C")) )