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

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
ShaunBuchan
Frequent Visitor

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

Hi,

 

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

 

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

 

IDCustomerBusiness Service ID
1A20
2A23
3B7
4C5
5A20
6A20

 

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 IDCustomer
20A
23A
24A
7B
5C
4C

 

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.

 

 

 

2 REPLIES 2
amitchandak
Super User
Super User

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

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

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)

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

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

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.