topic Total Sum of a column as a measure in DAX Commands and Tips

Total Sum of a column as a measure

NKTMS — Fri, 09 Aug 2024 08:52:36 GMT

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

Re: Total Sum of a column as a measure

aduguid — Fri, 09 Aug 2024 10:36:09 GMT

Try this measure

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

Re: Total Sum of a column as a measure

Anonymous — Mon, 12 Aug 2024 06:05:28 GMT

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