Go from messure to column

[Anonymous]

Hi,

I have created this messure that works as it shold. But what i really need is for it to be in column format so that I can calculate on it.

Can anyone help me with that?

Together = SUM('Forecast'[Quantity])+SUM ('Forbrukning'[Consumption])

Thanks in advance 🙂

[lbendlin]

Columns are tied to a specific table (measures are not). So at the very minimum you need to do something like

TogetherColumn = SUM('Forecast'[Quantity])+SUM (RELATED('Forbrukning'[Consumption]))

in the Forecast table.  Or the other way round, depending on the relationship between your tables. RELATED only works upwards, from the "*" table into the "1" table.