Forum Discussion

gene7135's avatar
gene7135
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] ))  ...
Need Help
  • Vvelarde's avatar
    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] ))

     

     

gene7135's avatar
gene7135
Regular Visitor
9 years ago

Sorry "Number of Days"   Should read P1100.

alanhodgson's avatar
alanhodgson
Icon for Solution Supplier rankSolution Supplier
9 years ago

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