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

 

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

 

Any ideas why?

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

     

     

7 Replies

  • 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