Forum Discussion
Measure based on different filters
Super UserCouple of questions:
How would you prevent a user from selecting nonsensical items like this:
How are you planning to compute the average in your earlier example?
Do you want a cartesian product, comparing each row in the left table to each row in the right table? That would be the average of 12 comparisons ? I don't think that makes much sense.
Nonsensical inputs should either result in 0 (if they select the same filters for both tables) or a negative (if they select to filter a later instance before an earlier one). One work around could be to return the absolute value, but I think the negative will help the users understand that their inputs are backwards.
The calculation should be the difference between the values returned for that job, then averaged.
I believe I need a DAX formula to link the two tables together via the job column, generates a column containing the duration calculations, and then returns the average of that column.
