Forum Discussion
Solved
Table with a measure
I would like to create a table something like below year is set for 2006, 2013 and 2018, and i can use measure like lookupvalue to find year's number of people. but the problem is Dax doesnt l...
Don't use LOOKUPVALUE unless you really have to.
Use proper table definitions DATATABLE function - DAX | Microsoft Learn
Implement your business logic as a calculated column rather than a measure, or use COALESCE.
lbendlin
Super User
Super UserPlease provide a more detailed explanation of what you are aiming to achieve. What have you tried and where are you stuck?