Forum Discussion
Solved
Count rows in lookup table based on specific values missing in fact table
(Updated this as my sample matrix was incorrect) Hi, I am still learning DAX and hope someone can help with this. I am looking for a way to create a measure that counts the number of entries...
You should be able to use a measure like this to get your desired result in your matrix visual.
Missing Registrations = COUNTROWS ( FILTER ( VALUES ( Registration[RegistrationID] ), ISBLANK ( CALCULATE ( COUNTROWS ( Attendance ), TREATAS ( VALUES ( Sessions[Session Number] ), Attendance[SessionNumberAttended] ) ) ) ) )If this works for you, please mark it as the solution. Kudos are appreciated too. Please let me know if not.
Regards,
Pat
You should be able to use a measure like this to get your desired result in your matrix visual.
Missing Registrations =
COUNTROWS (
FILTER (
VALUES ( Registration[RegistrationID] ),
ISBLANK (
CALCULATE (
COUNTROWS ( Attendance ),
TREATAS (
VALUES ( Sessions[Session Number] ),
Attendance[SessionNumberAttended]
)
)
)
)
)
If this works for you, please mark it as the solution. Kudos are appreciated too. Please let me know if not.
Regards,
Pat
- Great solution Pat, Gavin Just add 0 after the last bracket and you should get the exact result as you wanted.
