Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It 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!
User | Count |
---|---|
95 | |
86 | |
78 | |
72 | |
67 |
User | Count |
---|---|
110 | |
104 | |
84 | |
65 | |
63 |