How to get 1 column in a table report filtered by a slicer not in sync with the table

[LaurentN]

Hello,

I am a PowerBi beginner and would like to know if it is possible to create a table report that behaves like explained in the attached picture (according to the fact table I have).

I tried to do it with a DAX measure using the following formulas but it does not work as I wish : 

CALCULATE(SUM('Fact'[Invoice]),'Fact'[Customer] = SELECTEDVALUE('Fact'[Customer]))

CALCULATE(SUMX('Fact','Fact'[Invoice]),'Fact'[Customer]=SELECTEDVALUE('Fact'[Customer]))

The slicer does not filter the table in order to get all the product in the table even if the customer did not buy one.

I can provide a test pbix of necessary.

Is it possible to do it ?

Many thanks

[LaurentN]

Thank you @johnt75 it works perfectly

[johnt75]

Select the slicer, go to the Format pane and choose Edit interactions. Turn off the interactions between the slicer and any other visuals then either version of your measure code should work as intended

[LaurentN]

Hello @johnt75 ,

As you can see in the following screenshot, the interactions bteween the slicer and the table is off but the formula does not work. I have the same result if I select C1, C2 or C3.

[johnt75 · Accepted solution]

OK, different approach.

Turn the interactions back on, create a new table 

Customers = VALUES(Table1[Customer])

do not create a relationship from the new table to the fact table, and create the sum measure as

Customer Tot = CALCULATE( SUM(Table1[Invoice]), TREATAS( VALUES(Customers[Customer]), Table1[Customer]))