Column names in Summerize

[jonny772]

Hi All, very new at this and still figuring my way around.

Im slightly confused in this case, the command below works well and in the second summerize 

Fuelimport[fuelType] ends up in column Source

"Generation" ends up in the column Sink.

Ideally, I need these the other way around but cannot figure out how to do this as the summerize command is using Fuelimport[fuelType]

Any pointers on my misunderstanding would be appreciated!

----------------------------------------

CalCtable =

UNION(

SUMMARIZE(Fuelimport,

Fuelimport[Source],

"Capacity(kWh)", SUM(Fuelimport[currentUsage]),

"Sink","UK Demand"

),

SUMMARIZE(CALCULATETABLE('Fuelimport','Fuelimport'[Source]=="Generation"),

Fuelimport[fuelType],

"Capacity(kWh)", SUM(Fuelimport[currentUsage]),

"Sink","Generation"))

[tamerj1 · Accepted solution]

Hi @jonny772 
Please try

CalCtable =
UNION (
    SUMMARIZE (
        Fuelimport,
        Fuelimport[Source],
        "Capacity(kWh)", SUM ( Fuelimport[currentUsage] ),
        "Sink", "UK Demand"
    ),
    SELECTCOLUMNS (
        SUMMARIZE (
            CALCULATETABLE ( 'Fuelimport', 'Fuelimport'[Source] == "Generation" ),
            Fuelimport[fuelType]
        ),
        "Source", "Generation",
        "Capacity(kWh)", CALCULATE ( SUM ( Fuelimport[currentUsage] ) ),
        "Sink", Fuelimport[fuelType]
    )
)

[jonny772]

Brilliant thank you!