Group By This but not by that

[brianmsbc]

So im trying to Calculate at the "Measure" level which will produce a whole number output (1,2,3,4,5). Once this value is found, it needs to aggregate at the "Contract" level (one of three categories). So if i filter for one Contract, it should STILL be a whole number, but if i choose two contracts, it would be an average of the two (scores of 1 and 2 would aggregate to 1.5).

Right now im using SUMX(VALUES([Measure]),CALCULATE(formula)). This is aggregating the formula AFTER"Contract" selection is considered instead of BEFORE (so that instead of finding values of 1 and 2 equaling 1.5, it is aggregating at the contract level first to find either 1 or 2).

How do i alter my DAX formula so that it aggregates BEFORE it considers "Contract"?

[v-cherch-msft]

Hi @brianmsbc 

I cannot reproduce your scenario.Could you share a simplified data sample and expected output?Please follow this article How to Get Your Question Answered Quickly to post your data.

Regards,