Group By Won't Work - How to aggregate?

Hi theitguy,

---

• Can I filter the outcome of Measure2, for example only scores higher than 50 and those count those?

---

Do you want the table visual only show records where Measure2 is greater than 50? If so, you could apply the visual level filter as below:

• Can I create the average of the outcome of measure 1 afterwards?

---

Do you want to get the average outcome per Participant_ID per Unique_Test_ID? If so, please modify the formula for Measure1:

Measure1 =
DIVIDE (
    CALCULATE (
        SUM ( 'Learning Sessions'[Seconds_Spend] ),
        ALLEXCEPT (
            'Learning Sessions',
            'Learning Sessions'[Participant_ID],
            'Learning Sessions'[Unique_Test_ID]
        )
    ),
    CALCULATE (
        COUNTROWS ( 'Learning Sessions' ),
        ALLEXCEPT (
            'Learning Sessions',
            'Learning Sessions'[Participant_ID],
            'Learning Sessions'[Unique_Test_ID]
        )
    )
)

Best regards,

Yuliana Gu