October 13, 2016 at 12:17 am
Hi All,
I am currently working on SSAS tabular model and I am facing an issue when I slice on excel sheet as below:
I have 2 fact tables(Turnover and Space). Both the fact tables have relation with Property table in similar terms. When I slice on Property (BuildingName) as column and add value for measure "Last 12 months Turnover"(which comes from Fact table Turnover), it works fine. Whereas , when I slice on Space(BuildingName) and add value for measure "Last 12 months Turnover"(which comes from Fact table Turnover), it doesn't work. It gives same value(Ex 144, 144, 144,) throughout. There is no relation between the two fact tables. But the client requirement is to create measure for "Last 12 months Turnover" even when we slice on Space.
I even tried adding measures to relate the two tables(Facts), but it still doesn't work.
I am not sure how to achieve this.
Can somebody please help?
Please let me know if you need more detailed description of the issue, I can send the screenshots of relations.
Regards,
Shweta
October 13, 2016 at 9:23 am
Yes, please provide screenshots of your tables and relationships.
October 13, 2016 at 9:58 pm
I am not able to upload screenshots here. My attachment section is greyed out!! How do I upload files??
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply