Forum Discussion
Multiple Fact Tables Issue when you are attempting to use more than 1 non-conformed dimension
I have a very interesting reporting pattern that MicroStrategy handles seamlessly and we were expecting PowerBI to handle it just as easy. In our Warehouse we have mulitple fact tables with conforme...
Data-estDog
Resolver II
Resolver IIPlease look at my reply from 12 Oct and the screen shots. You need to use USERELATIONSHIP and spell out the joins so the model knows which patht to take.
Hey Data-estDog ,
First, it was very rude of me not to thank you for your suggestion. Thanks for taking the time to help me! I tried the Use Relationship on the new metric, but it did not seem to make a difference. I still got the cartisian between the metric on the Fact Table and the non conformed dim that had a relationship with another Fact Table. I tried every relationship in the model and it did not make a difference. Maybe I'm using it wrong? Let me take another stab at it.