Forum Discussion

Regular Visitor

9 years ago

Solved

Unable to create measure

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] )) ...

Vvelarde
9 years ago
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] ))

Community Champion

9 years ago

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] ))

Regular Visitor

9 years ago

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]))