Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

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...
Need Help
Tips and Tricks
  • v-easonf-msft's avatar
    v-easonf-msft
    5 years ago

    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's avatar
Jihwan_Kim
Icon for Super User rankSuper User
5 years ago

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/