Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
I am trying to use a measure to first check if a column has numeric values and only then sum those values.
Here is my code:
IF(
ISERROR( VALUE( SUM( 'Spreadsheet Cell'[Value] ) ) ),
BLANK( ),
VALUE( SUM( 'Spreadsheet Cell'[Value] ) )
)
However, it is giving this error:
The above formula works if I replace SUM with MAX (but only gives the max value, I am interested in getting the SUM).
Any help with this is appreciated. Thanks!
Solved! Go to Solution.
Can you try this @Khurram_Ahmed
MEASURE =
CALCULATE (
SUMX (
ADDCOLUMNS ( 'Table', "@double", CONVERT ( 'Table'[Column1], DOUBLE ) ),
[@double]
),
FILTER (
VALUES ( 'Table'[Column1] ),
NOT ( ISERROR ( CONVERT ( 'Table'[Column1], DOUBLE ) ) )
)
)
Can you try this @Khurram_Ahmed
MEASURE =
CALCULATE (
SUMX (
ADDCOLUMNS ( 'Table', "@double", CONVERT ( 'Table'[Column1], DOUBLE ) ),
[@double]
),
FILTER (
VALUES ( 'Table'[Column1] ),
NOT ( ISERROR ( CONVERT ( 'Table'[Column1], DOUBLE ) ) )
)
)
Hi, thanks a lot for helping with this. This is working!
Hi @Khurram_Ahmed,
Please try this:
IF(
ISNUMBER( SUM( 'Spreadsheet Cell'[Value] ) ),
SUM( 'Spreadsheet Cell'[Value] ),
BLANK()
)
Proud to be a Super User!
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
91 | |
81 | |
65 | |
65 | |
60 |
User | Count |
---|---|
170 | |
114 | |
102 | |
73 | |
69 |