Forum Discussion

ryand009's avatar
ryand009
Frequent Visitor
1 year ago
Solved

Values from Unrelated table

Hello   Part of my model is .. I need to count the number of StudentID's in Table_B that have matching values in Table_C based on a Regdate range from Table_B. I've got the folowing Dax expr...
Column Formula Assistance
  • vivek31's avatar
    vivek31
    1 year ago

    HI ryand009,

    you can use a VALUES instead of LOOKUPVALUE function

    EVALUATE
ROW(
    "j",
    CALCULATE(
        COUNTROWS(Table_B),
        FILTER(Table_B,
                Table_B[RegDate] >= DATE (2025, 1, 1) &&
                Table_B[RegDate] <= DATE (2025, 1, 31)),
                Table_B[StudentID] IN VALUES ( Table_C[StudentID])))
quantumudit's avatar
quantumudit
Super User
1 year ago

Hi ryand009 

Could you please provide sample data that fully represents your issue or question in a usable format, rather than a screenshot? Ensure the dataset is anonymized and does not contain any sensitive or unrelated information.

 

Additionally, it would be very helpful if you could share the expected outcome based on the provided data - this can be in any format, including a screenshot. Having a clear reference for comparison will significantly improve the chances of getting the correct solution in the first response.

 

For best practices, you may find the following links useful:

 

Thanks,

Udit