Forum Discussion
Solved
How to get 1 column in a table report filtered by a slicer not in sync with the table
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...
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]))
