Coutrows not showing in table visual when displaying related items

[Gandalf12345]

Hi out there,

I have a fairly simple model

Order Manager (OM-X) with "ID" being unique and connected 1:m uni to:

Plant with plan number ("TP") being unique and connected 1:m uni to

Production Task with "Task" being unique and conected 1:m bidirectional to

OfferNumber with "Offer#" bein unique

I want to show to the Order manager an overview of his #Tasks, #Offers and Offer value in a table visual.

That works almost perfectly.

The problem is that the Measure M-Ctr-WT = countrows(Tasks) does show a blank when I include the Offer# while it shows a correct 1, when I don't show the offer number. It is right that there is no offer, however it still stays a task and so it should display a 1.

Can you please help me solve this?

Best regards

Gandalf

[Gandalf12345]

Dear Wisdom Wu,

thank you very much for your reply.

if I have noch misunderstood, the calculated column should reside in the Task table. The problem is that PBI does not let me create it. It says there was no relationship. Maybe the problem is that 1 task can have n offers.

Hence, the whole process stops here. 

The model looks like that: Does this help?

Unfortunately, I cannot upload anything here and link sharing via OneDrive is disabled for us. Do you have any suggestion on how to transfer the model to you?

Kind regards

Gandalf

[Anonymous]

Hi @Gandalf12345 ,

Please try the following methods and check if they can solve your problem:

1.Create the new Column.

Column = RELATED(Offer[Offer#])

2.Create the new column to calculate.

M-wt = CALCULATE(COUNT('Production Task'[Task]),RELATEDTABLE('Production Task'))+0

You can also view the following link to learn information.

Solved: Table visualization not showing entries with blank... - Microsoft Fabric Community

If the above ones can’t help you get it working, could you please provide more raw data(exclude sensitive data) with Text format and table relationship to make a deep troubleshooting? It would be helpful to find out the solution.

Best Regards,

Wisdom Wu

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