Set default data based on specific rule filter

[gzai]

Hi all,

I have table :

Table_A

Client	Type	Category	Value
Client A	A	AA	10
Client B	B	AA	15
Client B	A	AB	8
Client C	C	AC	5
Client A	D	AB	13
Client D	E	AD	4
Client E	F	AE	7

Table_B ( duplicate from Table_A, remove other column except column Type, and set only specific Type )

Type

B

C

E

Table_A & Table_B have relationship many to one based on column Type

For visual I want to add slicer for column Type ( Multiselect ) and chart data based on Category. 
Slicer Type ( from Table_A )

------------

A

B

C

D

E

F

I have measure in Table_A to detect slicer Type when selected ( True / False ).

Filtered Type = CALCULATE(ISFILTERED(Table_A[Type]), ALLSELECTED(Table_A[Type]))

How to create a measure based on measure I've made,
when slicer Type is not selected, chart data only show default data based on all type in Table_B, 

and when slicer Type is selected single or multiple, chart data show based on selected.

Any Suggestion?

[gzai · Accepted solution]

After trying several times,

when using your measure, it's actually correct. but there is a little bug when using isfiltered. isfiltered will return true when nothing is selected (don't know how).

I finally combined your measure with measure I've made and make some changes.

Measure : 

Filtered Type =

IF(

CALCULATE(ISFILTERED(Table_A[Type]), ALLSELECTED(Table_A[Type])),

CALCULATE(SUM(Table_A[Value]),

ALLSELECTED(Table_A[Type])

),

CALCULATE(SUM(Table_A[Value]),

FILTER(Table_A, Table_A[Type] in ALLSELECTED(Table_B[Type]) )

)

)

Thanks @amitchandak 

[amitchandak]

@gzai , Try a measure like

Filtered Type = if(ISFILTERED(Table_A[Type]) , CALCULATE(count(Table_A[Type]), ALLSELECTED(Table_A[Type])) ,
CALCULATE(count(Table_A[Type]), filter(Table_A , Table_A[Type] in Table_B[Type])))

[gzai]

Hi @amitchandak ,

I have tried measure

Filtered Type = if(ISFILTERED(Table_A[Type]) , CALCULATE(count(Table_A[Type]), ALLSELECTED(Table_A[Type])) ,
CALCULATE(count(Table_A[Type]), filter(Table_A , Table_A[Type] in Table_B[Type])))

error "A single value for column 'Type' in table 'Table_B' cannot be determined. ..."

[amitchandak]

@gzai , Try like

Filtered Type = if(ISFILTERED(Table_A[Type]) , CALCULATE(count(Table_A[Type]), ALLSELECTED(Table_A[Type])) ,
CALCULATE(count(Table_A[Type]), filter(Table_A , Table_A[Type] in allselected(Table_B[Type]))) )

[gzai]

@amitchandak measure no error, but it seems for else logic is not correct.

Visual chart when no selected filter :
Total Value = 62 ( 10 (A) + 15 (B) + 8 (A) + 5 (C) + 13 (D) + 4 (E) + 7 (F) )

expected results when no selected filter :

Total Value = 24 ( 15 (B) + 5 (C) + 4 (E) )