Measure tables - recommended? Any problem?

Hi Ricardo77 ,

I don't know about live connections to tabular models, but in PBI Desktop there is no downside, only preference.

All of the fields in your measures need to be declared explicitly (full tableName[fieldName]) anyway regardless of whether they're in a measure table or not, so there's no extra work required.

I think best practice would probably dictate a hybrid approach to this where table-specific measures, such as

_noofSalesID = DISTINCTCOUNT(yourTable[salesID])

would stay in the table(s) to which they relate. Cross-table measures, such as

// Example only, this won't work!
_totalCost = SUM(sales[Quantity]) * SUM(items[Price])

would be placed in a measure table, as they don't relate to a single table.

Pete