My Sematic Model has multiple relationship to a single table and hence once one relationship is active and the rest are made to be inactive. How to do reporting using PowerView based on a Inactive relationship?shiv

Hi Shivd, Thanks for your posting. To use the inactive relationship when designing a Power View report, we can specify the relationship in the DAX. For the detailed information, please see Kasper's blog below: http://www.powerpivotblog.nl/powerpivot-denali-working-with-multiple-relationships-between-two-tables Hope this helps. Regards, Mike Yin TechNet Subscriber Support If you are TechNet Subscription user and have any feedback on our support quality, please send your feedback here.Mike Yin TechNet Community Support