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.
So the point is that whenever you add numbers together and there is a blank value, the result must always be blank. If the blank value does not appear in the sum of the column, then it is a number value.
How can you manipulate this outcome?
Table
Category | value |
a | 1 |
b | |
c | 3 |
The sum(table[value])
total = BLANK
Solved! Go to Solution.
Interesting and unusual requirement 🙂
You could use COUNTBLANK to determine if at least one BLANK value is present, and if so return BLANK, otherwise return the sum.
A concise way of putting it could be:
SUM modified =
IF (
NOT COUNTBLANK ( 'table'[value] ),
SUM ( 'table'[value] )
)
If the value returned by COUNTBLANK(...) is nonzero, it will be cast to the value TRUE, and then NOT COUNTBLANK(...) will be FALSE.
Does this work for you?
Interesting and unusual requirement 🙂
You could use COUNTBLANK to determine if at least one BLANK value is present, and if so return BLANK, otherwise return the sum.
A concise way of putting it could be:
SUM modified =
IF (
NOT COUNTBLANK ( 'table'[value] ),
SUM ( 'table'[value] )
)
If the value returned by COUNTBLANK(...) is nonzero, it will be cast to the value TRUE, and then NOT COUNTBLANK(...) will be FALSE.
Does this work for you?
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 |
---|---|
42 | |
21 | |
21 | |
14 | |
13 |
User | Count |
---|---|
43 | |
39 | |
33 | |
18 | |
17 |