Forum Discussion
0 if data is missing
Hi everyone,
I have the following problem:
I have 10 Materials, with Data for different dates. If I create a table (with the Materials an the Data for the months) with a filter for each month, I can only see the materials, which has data for the Month. How can I say, even when theres no data, I want to show all Materials and if there is data missing, its 0.
For example:
This is my test data:
| Material | data | date |
| 12345 | 1 | 01.01.2021 |
| 13245 | 1 | 05.01.2021 |
| 14324 | 1 | 02.02.2021 |
| 15683 | 1 | 03.02.2021 |
So, now I want to see in my table, every Material for the month January, but if the other 2 Materials has no data there, I want to show "0".
Do you have any ideas?
Hi, Anonymous
You can also try to using formula as below to repace your original field "data"
Measure= sum('Table'[data])+0If it doesn't meet your requirement,please share your expected result in excel.
Best Regards,
Community Support Team _ Eason
2 Replies
Hi, Anonymous
Please correct me if I wrongly understood your question.
I assume you want to create a table visualization.
Please try to write measure something like below.
Your measure = coalesce (sum( your data column), 0)
Hi, My name is Jihwan Kim.
If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.
Linkedin: https://www.linkedin.com/in/jihwankim1975/Hi, Anonymous
You can also try to using formula as below to repace your original field "data"
Measure= sum('Table'[data])+0If it doesn't meet your requirement,please share your expected result in excel.
Best Regards,
Community Support Team _ Eason
