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

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Helper I
Helper I

Tracking KPIs per Reps across multiple weeks

Hey All,


I am trying to track average compliance for each person per week.  This is kind of tricky because I also would like it to take the average compliance over multiple weeks if I select multiple weeks in the filter. I am displaying the count of compliant vs non-compliant in 2 cards. For example:


Person 1 Average Compliance:

- Week 1: 100%

- Week 2: 50%

- Week 3: 90%


Person 2 Average Compliance:

- Week 1: 95%

- Week 2: 10%

- Week 3: person quit job so had no data for this week


If the key metric is to have compliance >= to 90%, Person 1 would be compliant in week 1 & week 3 so he would be counted in the compliant card when either of those weeks are selected.  When I select all 3 weeks in the filter, the average compliance should be 80% so he would show in the non-compliant card for those weeks.  Similarly, person 2 would show compliant in week 1, non-compliant if week 1, 2, & 3 are selected even though he is no longer active during week 3.


Any help would be greatly appreciated.

Community Support
Community Support

Hi @Ryanb2412,

AFAIK, card visual not suitable for your requirement. Currently, it only allows you to use one field in it to display the aggregate value. Even if you select multiple items on the slicer, it also displays one aggregate value of selected items.

Since we not so clarify your data structure, can you please share some dummy data to test and coding formula?

How to Get Your Question Answered Quickly 


Xiaoxin Sheng

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.

Helpful resources

Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

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

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.