Measure needed to reduce denominator

[ghe7549]

Has anyone worked with a measure where if a facility does not have the ability to do something you remove the amount from the denominator so not to penalize the facility since they could not do that task.

Example would be if the total possible score you could get was 20 points and you had four different attributes to get to the 20 points all each worth 5 points but you did not have the ability to do attribute "A" and to not be penalized for not having the ability to do attribute "A" now you would only be able to get 15 points

[rsbin]

@ghe7549 ,

I would create a Dimension table for my Facilities.  Something like this:
FacilityAttributePoints

1	A	5
1	B	5
1	C	5
1	D	5
2	B	5
2	C	5
2	D	5

Join this Dimension table to your FACT table and then Sum on Points will give you the proper denominator.

Hope you can use this idea somewhere in your data model.

Regards,