Simple calculation over 2 or more fact tables? Is this possible?

[wming]

Build a very simple module with 2 fact table, 1 dimension table. Both fact table join to dimension table.

Create new dashboard, create simple calculation
test = fact1.measure1 + fact2.measure1

Drag test to the dashboard, also drag column from dimension table to the dashboard as filter. Unfortunately, when select value from list of filter, simple calculation test value is NOT changed as expecting. Monitor SQL script, selected filter value does not included to the script.

This basically means dashboard does not has the capability to analyze data from different fact table?

[bus_pass_man]

It works for me.  Is this what you were doing?

This basically means dashboard does not has the capability to analyze data from different fact table?

No, it works for me.