Showing results for 
Search instead for 
Did you mean: 
Helper I
Helper I

Matrix - Show Effect on Percentage with Row Value Removed

I have an accuracy measure, given as a percentage, for each customer, and I want to be able to show (in a matrix) what that percentage would be if I remove a particular item from the calculation.

For example, suppose the measure for Customer A is 75% across all items, but if Customer A bought none of Item 1, it would be 78%, and if they bought none of Item 2, it would be 64%. I want this:

ItemTotal AccuracyAccuracy with Item Removed
Item 175%78%
Item 275%64%
Super User
Super User

 if I remove a particular item from the calculation

How do you plan to do that?  A slicer fed by a disconnected table? 

Helpful resources

May 2023 update

Power BI May 2023 Update

Find out more about the May 2023 update.

Submit your Data Story

Data Stories Gallery

Share your Data Story with the Community in the Data Stories Gallery.

Top Solution Authors