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

     

     

alanhodgson's avatar
alanhodgson
Solution Supplier
9 years ago

Hey gene7135,

 

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

 

Best,

 

Alan

gene7135's avatar
gene7135
Regular Visitor
9 years ago

Does this help?

 

 

  • Vvelarde's avatar
    Vvelarde
    Community Champion
    9 years ago

    gene7135

     

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

    • gene7135's avatar
      gene7135
      Regular Visitor
      9 years ago

      Sorry "Number of Days"   Should read P1100.

      • alanhodgson's avatar
        alanhodgson
        Solution Supplier
        9 years ago

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