Forum Discussion

Heyang's avatar
Heyang
Frequent Visitor
2 years ago
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...
DAX
measure
Table
  • lbendlin's avatar
    lbendlin
    2 years ago

    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.

Heyang's avatar
Heyang
Frequent Visitor
2 years ago

Hi,

 

Thanks for the quick response.

 

 

I am trying to create a new table, and you can see row1 value3 isnt shown up. I guess the reason is [areaCodeForSelectedClub] is a measure and PowerBI doesnt like its not been static value?

and how do I fix it?

thanks in advance

Kind regards,

lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
2 years ago

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.

  • Heyang's avatar
    Heyang
    Frequent Visitor
    2 years ago

    Thank you.