Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello,
Not sure why this measure returns the error "The expression refers to multiple columns. multiple colulmns cannot be converted to a scalar value.
Solved! Go to Solution.
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())
Thank you. What ended up work is:
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())
Thank you. What ended up work is:
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" } ) )
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
Hi @Clint ,
the reason is that the FILTER formula returns a table as a result, while the CALCULATE formula should be used with a single number (single numbers are called 'scalar values' in Power BI).
What exactly do you want to obtain with the formula?
Regards,
LC
Shouldn't the filters there return a one cell table? I was hoping to return the value for percent complete for that one task in that one project
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
97 | |
85 | |
67 | |
59 |
User | Count |
---|---|
150 | |
120 | |
100 | |
87 | |
68 |