Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Missing Data in a Table

I am having an issue when I create a table … so for example, I have groups 1, 2, 3 who all have sales targets. I can pull in those sales targets for each group. Then I have a separate data set that h...
Need Help
  • v-lionel-msft's avatar
    v-lionel-msft
    5 years ago

    Hi Anonymous ,

     

    Since I don't understand your data model, I can not reproduce your problem. Please provide sample data model like me.

        

     

    In addition, I have also tried when the sales target is also empty.

     

    Best regards,
    Lionel Chen

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Thank you for the reply!! Can you provide more details - how do I go about creating a dimensions table vs. facts table? 

v-lionel-msft's avatar
v-lionel-msft
Community Support
5 years ago

Hi Anonymous ,

 

Since I don't understand your data model, I can not reproduce your problem. Please provide sample data model like me.

    

 

In addition, I have also tried when the sales target is also empty.

 

Best regards,
Lionel Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.