Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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"?
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,
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
136 | |
117 | |
101 | |
71 | |
61 |