Forum Discussion
Solved
cross frequency calculation
Hello community, I have a question related to the frequency golf players are linked to each other during a competition. Imagine players are grouped together in several flights during one day, an...
Hello Scottsen,
does seem indeed not being trivial !
However, this will definitely work for me. I will build it in my tables using your sample tables and statement.
Thanks very much again!
Cheers,
Joop
Tried to throw together a sample model here: Golfing.pbix
In fairness, this measure was... non-trivial. I'm actually wondering if somebody else has a better/easier way.
Together = IF (HASONEVALUE(Away[Person]) && HASONEVALUE(Home[Person]) && VALUES(Home[Person]) <> VALUES(Away[Person]),
SUMX(
SUMMARIZE(Tee, Tee[Date], Tee[Flight], "Together", IF(CONTAINS(Tee, Tee[Player], VALUES(Away[Person])) && CONTAINS(Tee, Tee[Player], VALUES(Home[Person])), 1, 0)),
[Together]
)
) Hello Scottsen,
does seem indeed not being trivial !
However, this will definitely work for me. I will build it in my tables using your sample tables and statement.
Thanks very much again!
Cheers,
Joop