topic Values from Unrelated table in DAX Commands and Tips

Values from Unrelated table

ryand009 — Thu, 27 Feb 2025 17:20:14 GMT

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 expression, that is returning a value, but not the correct one.

EVALUATE
ROW (
"j",
CALCULATE (
COUNTROWS(Table_B),
FILTER (
Table_B,
Table_B[RegDate] >= DATE (2025, 1, 1) &&
Table_B[RegDate] <= DATE (2025, 1, 31) &&
NOT (
ISBLANK (
LOOKUPVALUE (
Table_C[StudentID],
Table_C[StudentID],
Table_B[StudentID]
)
)
)
)
)
)

Thanks in advance

Roy

Re: Values from Unrelated table

Greg_Deckler — Thu, 27 Feb 2025 18:33:59 GMT

ryand009 Sorry, having trouble following, can you post sample data as text and expected output?
Not really enough information to go on, please first check if your issue is a common issue listed here: https://community.powerbi.com/t5/Community-Blog/Before-You-Post-Read-This/ba-p/1116882

Also, please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

The most important parts are:
1. Sample data as text, use the table tool in the editing bar
2. Expected output from sample data
3. Explanation in words of how to get from 1. to 2.

Re: Values from Unrelated table

quantumudit — Fri, 28 Feb 2025 07:21:06 GMT

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

Re: Values from Unrelated table

vivek31 — Fri, 28 Feb 2025 11:00:17 GMT

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])))