I've been stuck on this for a while, so I'm reaching out here for some help. I'm working with two calculated columns that take one value and turn it into another value 0-100 (from where we get the average of that value to represent performance). Then, I have a measure that counts a number of "True"s against "False"s to get a percentage of what falls into column A instead of column B, and then I use that percentage to weight column A v. column B into a kind of average.
With column A as "A", column B as "B", and the measure as "M", the formula I use looks like:
A * M + B * (1 - M)
With an example of an output for it being somewhere where column A averages to 80, column B averages to 40, and the value of M is 60%, so:
80 * .6 + 4 * (1 - .6) = 49.6
What I'm wondering is how do I make this work in DAX for a measure, and is it even something that's workable considering that M is a measure and I know there's limitations on calculating against a measure? Added to the fact that A and B are calculated columns but I'm interested in getting the average to work with the measure instead of just individual values in said columns.
