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.
I want to sum amounts based on a value that appears in a separate column. The formula I have tried is:
"Revenue = CALCULATE(SUM('Initiative Funding'[Amount]),ALLEXCEPT('Initiative Funding','Initiative Funding'[Funding Status]="Expected Revenue"))".
I am getting this error message:
"A single value for column 'Funding Status' in table 'Initiative Funding' cannot be determined. This can happen when a measure formula refers to a column that contains many values without specifying an aggregation such as min, max, count, or sum to get a single result."
I don't understand this error, as I am specifying the value required in the Funding Status column.
Steve
Hi @kennoe,
Please try this:
Revenue = CALCULATE ( SUM ( 'IF_Example41'[Amount] ), FILTER ( ALLEXCEPT ( 'IF_Example41', 'IF_Example41'[Funding Status] ), SELECTEDVALUE ( IF_Example41[Funding Status] ) = "Expected Revenue" ) )
Best regards,
Yuliana Gu
Thank you. The amended formula removes the error message, however it does not show any values in the table. Things I noticed when trying to get a solution:
Steve
Proud to be a PBI Community Champion
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 |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |