Logical OR filter in Tabular model

• transfering

  Old Hand

  Points: 369

  More actions

  February 8, 2016 at 2:34 pm

  #311323

  Hello. I have a problem designing tables and relationships in our business. I have a main fact table that contains calculations by employees. Each employee has, however, a primary and secondary area of operation, which may be the same or different. At the end, I want to choose one area and elicit fact information (Sales Amount) whether the employee has selected primary or secondary area of operation. I try to do this in MS SSAS 2012 Tabular model and so far I have 2 scenarios:

  1) D_Regions -< Bridge >- D_Employee -< FACT

  In Bridge table there will be 2 rows for each Employees. First with Primary Area, Second with Secondary area. Calculations doesn't work.

  2) D_Primary_Region -< FACT >- D_Secondary_Region

  ` ` |_______ D_Regions ________|

  Here somehow we have to implement Logical OR.

  I would greatly appreciate all ideas and help!