The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event! Join us in Stockholm, Sweden from September 24-27, 2024.
2-for-1 sale on June 20 only!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
Dear PBI Community,
I want to calculate productivity value (Screen shot 1 , measure in my report) based on the highlighted "selected FY " ( year that user will select from filter ..the screen shot 2 below shows details / calculations of measure selected FY
Screenshot 1 :
Screen shot 2 :
I am getting the following error, please help°!!
Multiple Columns cannot be converted in to a Single Value
Solved! Go to Solution.
The error message "Multiple Columns cannot be converted into a Single Value" typically occurs when a DAX function expects a single value but receives multiple values instead. In your case, it seems like the error is related to the use of the [Selected FY] measure within the FILTER function of your Productivity measure.
To resolve this issue, you can try using the VALUES function inside the FILTER to ensure that only a single value is passed to the filter context. Here's how you can modify your Productivity measure:
```dax
Productivity =
DIVIDE(
SUM('ReportingData V_ATLAS_OL'[Picked lines (total)]),
SUM('ReportingData V_ATLAS_OL'[Productive hours]),
FILTER(
'ReportingData V_ATLAS_OL',
'ReportingData V_ATLAS_OL'[FYDate Y] = VALUES('ReportingData V_DIM_Dates'[FYDate Y])
)
)
```
By using the VALUES function inside the FILTER, you ensure that only a single value from the 'ReportingData V_DIM_Dates'[FYDate Y] column is passed to the filter context, resolving the error related to multiple columns being converted into a single value.
Please replace 'ReportingData V_DIM_Dates'[FYDate Y] with the appropriate column reference from your 'DIM-Dates' table. This modification should help resolve the error you're encountering. If you continue to experience issues, feel free to provide additional details, and I'll be glad to assist you further!
Did I answer your question? Mark my post as a solution! Appreciate your Kudos !!
The error message "Multiple Columns cannot be converted into a Single Value" typically occurs when a DAX function expects a single value but receives multiple values instead. In your case, it seems like the error is related to the use of the [Selected FY] measure within the FILTER function of your Productivity measure.
To resolve this issue, you can try using the VALUES function inside the FILTER to ensure that only a single value is passed to the filter context. Here's how you can modify your Productivity measure:
```dax
Productivity =
DIVIDE(
SUM('ReportingData V_ATLAS_OL'[Picked lines (total)]),
SUM('ReportingData V_ATLAS_OL'[Productive hours]),
FILTER(
'ReportingData V_ATLAS_OL',
'ReportingData V_ATLAS_OL'[FYDate Y] = VALUES('ReportingData V_DIM_Dates'[FYDate Y])
)
)
```
By using the VALUES function inside the FILTER, you ensure that only a single value from the 'ReportingData V_DIM_Dates'[FYDate Y] column is passed to the filter context, resolving the error related to multiple columns being converted into a single value.
Please replace 'ReportingData V_DIM_Dates'[FYDate Y] with the appropriate column reference from your 'DIM-Dates' table. This modification should help resolve the error you're encountering. If you continue to experience issues, feel free to provide additional details, and I'll be glad to assist you further!
Did I answer your question? Mark my post as a solution! Appreciate your Kudos !!
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.
User | Count |
---|---|
105 | |
97 | |
80 | |
62 | |
57 |
User | Count |
---|---|
246 | |
119 | |
114 | |
86 | |
70 |