problems with filters of a multipart fact

[vitexo87]

I'm with a prblema I hope eplicar clearly.

I have a dw with varis facts and all the facts has several fields in common, one of these fields is the month_id.

I make the burden of these facts in my power bi application and then concatenate all to become one fact only.

the problem is when I do some filters, as reported not all facts have the same fields with month_id and when I filter a month has indicators that due to have a field of a fact that had not month_id the indicator in question is null, I tried to add the month_id in all facts before concatenate however is not possible.

Any suggestions how to solve this?

[v-ljerr-msft]

@vitexo87

---

I make the burden of these facts in my power bi application and then concatenate all to become one fact only.

the problem is when I do some filters, as reported not all facts have the same fields with month_id and when I filter a month has indicators that due to have a field of a fact that had not month_id the indicator in question is null, I tried to add the month_id in all facts before concatenate however is not possible.

---

According to your description, the problem with filters may related to that not all facts have the same fields with month_id. So adding the month_id in all facts may solve the issue. What do you mean “add the month_id in all facts before concatenate however is not possible”? Where the problem occurs when you try to add the month_id in all facts? Does it throw any error? It will be better if you could post some sample data.

Regards

[KGrice]

Hi @vitexo87. Can you post a picture or sample of your table structure and where the problem occurs? Thanks.