Solved

Karbon Practice Intelligence: Field that should be available is not available for use in a measure

  • 11 November 2022
  • 4 replies
  • 44 views

Userlevel 7
Badge +15
  • Sr. Karbon Community Guide
  • 814 replies

Per this article: https://help.karbonhq.com/en/articles/6524704-kpi-table-and-column-names

BUDGETED_COST

The budgeted cost for a work item.

is an available field in table: WORK_ITEM_DETAILS

When I try and create a measure in that table, I can’t use the field BUDGETED_COST.

Anybody know how to resolve?

icon

Best answer by max 11 November 2022, 18:21

View original

4 replies

Userlevel 6
Badge +10

Following!  We can’t get this either.  

Userlevel 7
Badge +19

It’s generally good practice to nest measures, and the first argument for a calculate function is a calculation.

I would recommend adding a measure like this:

msr-bud-cost = SUM(BUDGETED_COST)

Then nest that measure in your calculate statement:

msr-bud-cost-filtered = CALCULATE(msr-bud-cost, department = "Accounting", etc., etc.)

Does that work better?

Userlevel 7
Badge +15

Thanks @max, that’s my rookie mistake 😅 apparently our PowerBI expert had tried it within a calculation function but it didn’t work, it is now though 🙂

Userlevel 7
Badge +19

It should work both ways, but there are some technical and arcane reasons why it makes sense to nest the measures like that.

Reply