Forum Discussion
Solved
Calculation in unrelated tables
Hi, I have a very simpel model. In this model we have products we buy at different providers. We have multiple units ( in this case customers) who have to set a yearly budget to spend per prod...
Jbogaert , You have to create measure as calculated columns can not use slicers
A measure can use values of independent tables like
Calculate(Sum(Table[Value]),Filter(Table, Table[Product] in values(Porduct[Product]))
also, refer
Need of an Independent Table in Power BI - Exclude: https://youtu.be/lOEW-YUrAbE
Compare two Brands: https://youtu.be/exN4nTewgbc
amitchandak
Super User
Super UserJbogaert , You have to create measure as calculated columns can not use slicers
A measure can use values of independent tables like
Calculate(Sum(Table[Value]),Filter(Table, Table[Product] in values(Porduct[Product]))
also, refer
Need of an Independent Table in Power BI - Exclude: https://youtu.be/lOEW-YUrAbE
Compare two Brands: https://youtu.be/exN4nTewgbc
Thx!
it worked