Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
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
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
142 | |
80 | |
63 | |
52 | |
48 |
User | Count |
---|---|
211 | |
87 | |
80 | |
69 | |
60 |