0 if data is missing

[Anonymous]

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?

[v-easonf-msft · Accepted solution]

Hi, @Anonymous 

You can also try  to using formula as below to repace your original field "data"

Measure= sum('Table'[data])+0

If it doesn't meet your requirement,please share your expected result in excel.

Best Regards,
Community Support Team _ Eason

[Jihwan_Kim]

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/