Need Help understand the logic of this DAX (will provide context)

[Anonymous]

Hi all,

I'm looking at someone else's project/dax right now and want to clarify this here: 

Hours Saved = SUMX(QueueDB, RELATED(queuesROI[timeValueMin]))/60

It's being used as a measure to Calculate the hours saved between Robots doing tasks vs. the Process Baselines (how long it takes person which is queuesROI[timeValueMin] - The dividing by 60 is to turn minutes into hours. 

I just don't understand what's being summed. I would assume we'd be summing the transaction execution time, but after referencing the table, it doesn't show a column being summed?

If anyone could dumb this down for me, I'd appreciate it.

Thank you

[Anonymous]

Your measure does exactly what this measure does:

[Hours Saved] =
calculate(
	sum( queuesROI[timeValueMin] ) / 60,
	crossfilter(
		// KeyTo_queuesROI and Key are fields
		// on which the tables join to each
		// other.
		QueueDB[KeyTo_queuesROI],
		queuesROI[Key],
		BOTH
	)
)

[Jihwan_Kim]

Hi,

I do not know how your data model looks like, but the concept of the measure that you showed is showing the calculation of the below. I might simplified too much but please share your sample pbix file, then I can try to look into it to come up with more relevant explanation.

Link to the sample pbix file