Forum Discussion

Giu's avatar
Giu
Frequent Visitor
3 years ago

Modelling double fact tables -Star schema

HI all,

I have a question about the schema below
.
I want to create a report starting and filtering from one or more "agreements"

I'd like to include into the same report a matrix with events for type for each person included in the selected agreements.

Relations:
- agreements - person many to many
- person - events many to many
- No relations agreements - events

Constraints:
- No double filter direction
- No Dax code

 

Any idea how to do it ?
Thanks
Giuseppe

No RepliesBe the first to reply