error on using multiple facts

[MAJLI]

hi .
can anyone tell mi why i take this messege when i try to do a count to a field.so first i do a IF-then-else clause.
and then i want to take the total number of fields and the total amount of the fields and when i try to run the report i take this message :
"QE-DEF-0328 The FOR-clause in expression 'count(if ([DWH V2.2.2 Core].[Account Balances].[Cleared Balance in Local Currency] > 0) then ([DWH V2.2.2 Core].[Accounts Active Link].[Approved Overdraft Amount]) else null for any [DWH V2.2.2 Core].[Accounts Active Link].[Branch Code])' is illogical because the expression contains multiple facts.

Trace back:

WPBIBusMethod.cpp(176): WPDataRetrievalException: CCL_CAUGHT: WPBIBusMethod::run"
thanks
"

 

[KingCrab]

Are you using Star scheme groupings? Do you have a bridge/stitch table to join these 2 facts together?
Are you including a field from a conformed dimension so it knows how to link these 2 tables?

You could also just throw it into 2 tabular models and filter on table1.a = table2.a or something similar