Forum Discussion

LMSReportsHelp's avatar
LMSReportsHelp
Frequent Visitor
2 years ago
Solved

Create Measure from data across multiple rows.

I have a set of learning data in which learners are assigned between 1-3 Class names. Because these classes are tied to security roles, they technically have to complete all 3, but the leadership on ...
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi LMSReportsHelp 

     

    Thanks for the reply from Ashish_Mathur . Here I have another idea in mind, and I would like to share it for reference.

     

    LMSReportsHelp , you can try to create a measure as follows.

    Registered? = 
VAR _count = CALCULATE(COUNT('Table'[Student ID]), FILTER(ALLEXCEPT('Table', 'Table'[Student ID]), [Class ID] <> BLANK()))
RETURN
IF(_count <> BLANK(), "Yes", "No")

     

    Output:

     

    Best Regards,
    Yulia Xu

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi LMSReportsHelp 

 

Thanks for the reply from Ashish_Mathur . Here I have another idea in mind, and I would like to share it for reference.

 

LMSReportsHelp , you can try to create a measure as follows.

Registered? = 
VAR _count = CALCULATE(COUNT('Table'[Student ID]), FILTER(ALLEXCEPT('Table', 'Table'[Student ID]), [Class ID] <> BLANK()))
RETURN
IF(_count <> BLANK(), "Yes", "No")

 

Output:

 

Best Regards,
Yulia Xu

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.