Visual chart or table with one fixed value and other from slicer

[Giadev]

Hi,

I need to create some visuals (both chart and table) with one fixet value and other from a slicer...

TABLE
Date	Account	Value
01/01/2021	A	2435
01/01/2021	B	243
01/01/2021	C	541
02/02/2021	A	11656
02/02/2021	B	653
02/02/2021	C	890

SLICER

A

B

A is selected and C in hidden (filtered ount in slicer)

VISUAL TABLE
44197	A	2435
44197	C	541
44229	A	11656
44229	C	890

Any ideas?

Thanks

[DataZoe · Accepted solution]

@Giadev A solution for this is to create an Accounts table without the fixed one, then set up an inactive relationship to the Accounts table. A measure then can bring in the fixed account value and the selected account value.

Accounts Slicer table:

Account Slicer = SUMMARIZE(filter('Table','Table'[Account]<>"C"),'Table'[Account])

Model:

Measure:

Measure = CALCULATE(sum('Table'[Value]),USERELATIONSHIP('Account Slicer'[Account],'Table'[Account]))+CALCULATE(sum('Table'[Value]),filter('Table','Table'[Account]="C"))

Then use the Measure and Accounts from first table in your visual:

[Giadev]

thank you, that's a good solution. is there a way to show C even if you don't select anything in the slicer?

[Giadev]

resolved

Measure =

CALCULATE(

IF(SELECTEDVALUE('Account Slicer'[Account])=BLANK(),

CALCULATE(sum('Table'[Value]),FILTER('Table','Table'[Account]="C")),

CALCULATE(sum('Table'[Value]),USERELATIONSHIP('Account Slicer'[Account],'Table'[Account]))+CALCULATE(sum('Table'[Value]),FILTER('Table','Table'[Account]="C"))))

[DataZoe]

@Giadev Yes, perfect!