Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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?
Solved! Go to Solution.
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] ))
Hey @gene7135,
Please share a screenshot of your data structure. There is probably something off in the relationship.
Best,
Alan
Does this help?
Sorry "Number of Days" Should read P1100.
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] ))
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]))
Looks like a data type issue. What are the data types for the Date columns?
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
100 | |
75 | |
73 | |
49 |
User | Count |
---|---|
145 | |
109 | |
109 | |
90 | |
64 |