Total Sum of a column as a measure

[NKTMS]

In this table, I wasn 80Mil against all the machinetypes. I created the measure electricity total usuage like this:

Electricity Total Usage =

CALCULATE(

    SUM('Fact ResourceUsage'[Usage]),

    'Fact ResourceUsage'[ResourceTypeKey] = 1,

    ALL('Fact ResourceUsage'[MachineTypeKey])

)
But its just giving the total consumption of that particular machine type

[aduguid · Accepted solution]

Try this measure 

Electricity Total Usage =
CALCULATE(
    SUM('Fact ResourceUsage'[Usage]),
    'Fact ResourceUsage'[ResourceTypeKey] = 1,
    REMOVEFILTERS('Fact ResourceUsage'[MachineTypeKey])
)

[Anonymous · Accepted solution]

Hi aduguid ,thanks for the quick reply, I'll add more.

Hi @NKTMS ,

Make sure that the field you use in your visuals is from the fact table and not from the dimension table.

Or check if you are referencing the wrong column in DAX.

If I understand you wrongly, please provide simple data and show the expected results in pictures.

How to provide sample data in the Power BI Forum - Microsoft Fabric Community

Best Regards,
Wenbin Zhou

[aduguid · Accepted solution]

Try this measure 

Electricity Total Usage =
CALCULATE(
    SUM('Fact ResourceUsage'[Usage]),
    'Fact ResourceUsage'[ResourceTypeKey] = 1,
    REMOVEFILTERS('Fact ResourceUsage'[MachineTypeKey])
)