Showing results for 
Search instead for 
Did you mean: 

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

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

PBI November 2023 Update Carousel

Power BI Monthly Update - November 2023

Check out the November 2023 Power BI update to learn about new features.

Community News

Fabric Community News unified experience

Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.

Power BI Fabric Summit Carousel

The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors