Optimization Question - Embedded Measures

[SimonNU]

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

 

[scottsen]

It's a great question. I really don't THINK you would see a diff, but ... I will research

 

[scottsen]

Nested Measure Performance | Power Pivot | Tiny Lizard

 

[SimonNU]

Thanks Scott!