Forum Discussion

Marcin's avatar
Marcin
Helper V
6 years ago

Two relationships

Hi,   I would like to ask for help with this case.    I have a model with one fact table and one category dimension witch selectes users by two different logics.    I would like to built two me...
Need Help
Thejeswar's avatar
Thejeswar
Super User
6 years ago

Hi Marcin ,

How are you going to define the path the the Model should take for displaying the data in the report?

 

Rgds,

  • Marcin's avatar
    Marcin
    Helper V
    6 years ago

    Hi Thejeswar 

    I would like to create a measure on fact table like for example DISTINCTCOUNT(FactTable[User]) and present it by Date , but the challenge is to be able to Filter this measure by Group Dim [Category name] in two different logics. ( LDAP and MU Group ). To be more specific, there should be two measures, one filtered by LDAP way and second by MU Group way. 

     

     

    • Thejeswar's avatar
      Thejeswar
      Super User
      6 years ago

      Hi Marcin ,

      When you are connecting the Fact table by 2 flows, one of the flow won't work as there would always be a problem with defining which flow should work.  Ultimately, if I am not wrong, the system is going to decide it ğŸ™‚

       

      Instead have two similar fact tables with respective measures based on the flow.

      Then introduce a bookmark and add similar slicer to the bookmark pages and sync them. This will allow the selection in the slicer to run across bookmarks. Now give an image or some clickable option for the users to chose the flow based on which the data has to be displayed. Based on the selection render the bookmark. Hope this helps

       

      Regds,