Forum Discussion

Clint's avatar
Clint
Helper V
6 years ago
Solved

Question about error in Measure: Expression refers to multiple columns

Hello,   Not sure why this measure returns the error "The expression refers to multiple columns.  multiple colulmns cannot be converted to a scalar value.    Task Percent Completed for Customer ...
Need Help
  • v-frfei-msft's avatar
    v-frfei-msft
    6 years ago

    Hi Clint ,

     

    As we know, we cannot create dynamic calculated table/ column. Here we can use table visual and a measure to work around.

    Measure = var a = MAX('Table'[Task Name])
return
IF(a  in  { "Customer Program" },"yes",BLANK())

     

  • Clint's avatar
    Clint
    6 years ago

    Thank you.  What ended up work is:

    M_Program Progress =

    DIVIDE(
    Value(
    MAXX(
    CALCULATETABLE('Tasks',
    'Tasks'[Task Name]="Customer Program"),
    'Tasks'[Task Percent Completed])),100)
v-frfei-msft's avatar
v-frfei-msft
Community Support
6 years ago

Hi Clint ,

 

Please update your formula as below.

Task Percent Completed for Customer Program =
CALCULATE (
    COUNTROWS ( 'Tasks' ),
    FILTER ( 'Tasks', 'Tasks'[Task Name] IN { "Customer Program" } )
)
Clint's avatar
Clint
Helper V
6 years ago

Hello,

 

This 

CALCULATE (
    COUNTROWS ( 'Tasks' ),
    FILTER ( 'Tasks', 'Tasks'[Task Name] IN { "Customer Program" } )
)

just returns the count of 1 telling me there is only one task with that name.  What I need to return is the value of the "Task percent Complete" for that task