Unable to create measure

[gene7135]

I am sure this is a newbie question.

I have trying to create a measure with the following DAX formula.

Submit Count = Divide(Count('Raw Data'[Repair Order]), 'Working Days'[Num of Days] ))

I do have a relationship between the two table, but the intellisence refuses to see the "Working Days" table.

Any ideas why?

[alanhodgson]

Hey @gene7135,

Please share a screenshot of your data structure. There is probably something off in the relationship.

Best,

Alan

[gene7135]

Does this help?

[Vvelarde]

@gene7135

Can't see [Num of Days] in the table Working Days

[gene7135]

Sorry "Number of Days"   Should read P1100.

[Vvelarde · Accepted solution]

@gene7135

You need to add a aggregation to Num of Days

Something Like: (Sum, Count, Min,Max, Values.etc)

Submit Count = Divide(Count('Raw Data'[Repair Order]), Sum('Working Days'[Num of Days] ))

[gene7135]

Thanks.    That's just what I realized.

The "Monday Date" in Working Days" is Date

The "Monday of Submit Date" was Date/Time,  I changed it to Date.

I think I found the issue.  At least it's does not give an error.

Here is the formula.

Submit Count = Divide(Count('Raw Data'[Repair Order]), SUM('Working Days'[P1100]))

[alanhodgson]

Looks like a data type issue. What are the data types for the Date columns?