Optimization Question - Embedded Measures

SimonNU

Board Regular
Joined
Jul 11, 2013
Messages
140
Would a measure process slower if there are many embedded measures inside of it?

A basic example for illustrative purposes: which would be a quicker measure for [Bikes]:

1. Generic Amount:=SUM([Col a])
Bikes:= CALCULATE([Generic Amount],[Col b] = "Bikes")

2. Bikes:= CALCULATE(SUM([Col a]),[Col b] = "Bikes")



Simon
 

Some videos you may like

Excel Facts

Format cells as currency
Select range and press Ctrl+Shift+4 to format cells as currency. (Shift 4 is the $ sign).

scottsen

Well-known Member
Joined
Mar 16, 2014
Messages
1,263
It's a great question. I really don't THINK you would see a diff, but ... I will research :)
 

Watch MrExcel Video

Forum statistics

Threads
1,112,865
Messages
5,542,960
Members
410,579
Latest member
bdubz
Top