Sum for 2 tables without filter

[Anonymous]

Hi Everyone,

I would like to SUM value with joined 2 tables in the picture below.

I try to use DAX formula for Forecast_Value: CALCULATE(SUM(BrandForec[Forecast_Value]), ALL(BrandForec[Brand&Type])) doesn't work! that was shown result as 80 but I want 280 (A A + A B).

[lbendlin]

What part does the left table play in your scenario? How are the tables joined?

[Anonymous · Accepted solution]

Hi Ibendlin,

I have solved this solution already by creating master data of Brand&Type and joined with 2 tables.