Count rows in a table for a category in a different table

[ShaunBuchan]

Hi,

I have searched the forums but couldn't find a solution.

I have an incident table which has [ID,Customer,Business Service IDetc]

ID	Customer	Business Service ID
1	A	20
2	A	23
3	B	7
4	C	5
5	A	20
6	A	20

A business service table which has [business service ID, customer etc]. Business service ID was used to create the relationship between the two tables.

Business Service ID	Customer
20	A
23	A
24	A
7	B
5	C
4	C

I have created a power bi report with a table where I selected business service ID and metrics such as incident count for this business service ID. I want to compare the incident count for that specific business service to the average for the customer(customer can have multiple business services) within the report table.

How can I create a measure to overrule the automatic filtering within the table but not the slicers?

Thanks.

[amitchandak]

@ShaunBuchan ,Can you share sample output in table format?

[ShaunBuchan]

Note that 20,23,24 are company A.

The company average and incident ticket count adjust according to a monthly date slicer.

Business Service ID    Tickets Opened   Delta from Previous Month     Delta from Company Average

       20                                  2                                (-1)                                            (-2)

       23                                  4                                (+3)                                           (0)

       24                                  6                                (-5)                                            (+2)