Need help creating a measure

[mehlenbae2]

I have a matrix that looks like this:

                  Type A   Type B Type C   Type D Type E Type F

Region 1	0.00%
Region 2	0.00%
Region 3	100.00

I need help creating a matrix that shows percent average for each region and Type. Problem is, each Type has a different target and i'd like to use different conditional formatting for each Type. I created 6 columns that show 1 if we met customer satisfaction and 0 if we did not meet customer satisfaction. However, each type is looking at the whole table instead of its specific type making the number way too small.. How can I remedy this for each type??

[Greg_Deckler]

@mehlenbae2 Try a single measure like:

Measure =
  VAR __Type = MAX('Table'[Type])
  VAR __Region = MAX('Table'[Region])
  VAR __Target = SWITCH(__Type,
                   "Type A",10,
                   "Type B",20,
                   "Type C",15
                 )
// do some more stuff here based on targets, etc.

[mehlenbae2]

@Greg_Deckler Sorry, I don't think I was clear.  The targets are not the issue- I need to make sure that each SPECIFIC Type gives a percent average based on the type SUM.

For example, for Type A (Met Customer Satisfaction = 50 | Did not meet customer satisfaction: 50) 

I need to find the average of Met customer satisfaction and did not meet customer satisfaction which in this example would be 50%^^ then split it up by Region.

My issue is that the columns I made look at the entire data set and do not filter the specific Type which makes the average incorrect because it's averaging by rows that are not applicable (other types).  I hope this makes sense. Sorry I am unable to attach the file due to the data sensitivity.

[Greg_Deckler]

@mehlenbae2 So are the Types actually in your data or are those coming from a disconnected table? Sample data would really help make heads or tails of this. I don't need actual data, just data that replicates the issue or otherwise simulates the data.

[mehlenbae2]

@Greg_Deckler 

Here is an Excel sheet. I am trying to replicate this in PBI by using a matrix:

Here is my table:

My issue is that I need to create a measure to calculate average Customer Satisfaction for each Product Type because of conditional formatting (each product type has different customer satisfaction target). However, when I average a product type it looks at the entire table instead of the rows that specify the Target Type. Keep in mind I need all of the Product Type values in the Matrix seperately. I am aware that it works perfectly when you put Product Type as Columns and average it that way however conditional formatting will not work the way I want it.

I would attach my test PBI but am not sure how.. Here is a picture:

Thank you very much!