Forum Discussion
Showing rows with NULL value in report
I'm working with a measure which count total value to a column and want to show the following table in report:
| Prod_id | Value |
| 45ret154 | 15.5 |
| vdf514gr | NULL |
| kjybh898 | 7.5 |
| liojki867 | 47.90 |
| qrdep67 | NULL |
| Total | 70,9 |
Total value =
SUMX(
SUMMARIZE('fact',
,('fact'[Prod_id])
,"Total",MAX('fact'[Value])
)
,[Total]
)
but it shows this in report:
| Prod_id | Value |
| 45ret154 | 15.5 |
| kjybh898 | 7.5 |
| liojki867 | 47.90 |
| Total | 70,9 |
Measure works fine but in table in report it does't show rows with NULL value, I need to have all Prod_id in report. How should I change the measure to have all prod_id in report?
You can add + 0 to your MAX expression.
Pat
4 Replies
- mahoneypat
Microsoft Employee
You can add + 0 to your MAX expression.
Pat
mahoneypat Thank you for your reply but can you please give an example?