Using Bridge Tables, stopped working, except for one value..

[patrick3]

EDIT:

Done some more experimenting - looks like it's got to do with certain measures, as some work and other's don't.

Can't find what makes the difference, i.e. I've got 3 Revenue related measures:

1. Revenue, just a sum() of a column
2. Revenue from Online Orders, the sum() of the same column, just wrapped in a Calculate function 
3. Last Months Revenue, which is wrapping the Revenue measure into a Calculate function using PREVIOUSMONTH

Any idea's what could cause this behaviour?

===========================================================================

Hi all,

So I've got a fairly complex model, but at it's core the problem is simple.

Using a bridge table to connect 2 seperate tables - 1 containing the actual leads, 1 containing the targets.

They both have a column called Sub-Category, which have been connected to the bridge table with the corresponding values.

Now I'm using the bridge table to display 2 measures, 1 to sum the leads, 1 to sum the targets.

It doesn't work - except for one particular sub-category...

That's the core problem - the practical reality is it seems to be applying across 2 dimensions, but not others (i.e. date & lead owner dimensions work fine).

Lastly - I've been using the same model for months, no issues. All I did was update the data with the new targets and poof, this happened. 

Any thoughts on what might be causing it?

Thanks,

Patrick

[Icey]

Hi @patrick3 ,

I can't reproduce your issues. Maybe you can give me your 3 tables' structures and some sample data.

Best Regards,

Icey

[patrick3]

Hi @Icey I'm afraid not - I can't reproduce the issue in a seperate model either and can't give you the full model.