Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
ghe7549
Helper III
Helper III

Measure needed to reduce denominator

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

1 REPLY 1
rsbin
Super User
Super User

@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,

Helpful resources

Announcements
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.