Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Solution for two facts with different granularity

Hello

In our project, the objective is to combine two facts of different granularity.
One fact has the lowest level at 'type vergoeding' while the other one has the person as lowest level
(A person has multiple 'type vergoeding')

Logically i get the outcome above.

But i want to have the outcome below.

Is this possible? The FE column should calculate the FE measure, for the rows where 'type vergoeding' = WEDDE

Granularity

3 Replies

  • lbendlin's avatar
    lbendlin
    Super User
    2 years ago

    Does it have to be a table visual or can it be a matrix?

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    If it can be solved, table or matrix is both okay. But FE is not the only measure that has to react this way.
    I wanted to apply the logic that works for FE for the other values 

    • lbendlin's avatar
      lbendlin
      Super User
      2 years ago

      In a matrix you can disable stepped layout and switch off row totals to achieve your desired layout.