I currently have the formula below entered as a measure in a drill in a pivot table. The formula works perfectly in the bottom level of my drill, but does not work for the upper levels. For instance, I have the following selections in my drill: County, Service Line, Specialty, Provider. The measure only works in the "Provider" level of the drill. How can I get it to work in all levels? The other measures work throughout the drill.