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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
TomSinAA
Helper III
Helper III

% calculation in a matrix

I have a measure to calculate the percentage one sum over another sum.  I am displaying it in a Matrix visual by month but the same % shows for each month.

 

The measure formula is: 

% Pickup Entered = (DIVIDE(Sum(tbl_KPIMatrix[ShipmentCountPickupComplete]),Sum(tbl_KPIMatrix[ShipmentCountPickup])))
 
Screen shot below
 

 

TomSinAA_0-1653073951210.png

 

2 REPLIES 2
v-cgao-msft
Community Support
Community Support

Hi @TomSinAA ,

 

In my case the measure is correct, would you mind providing more data?

vcgaomsft_0-1653556735042.png

How are these two fields counted in the matrix? 

vcgaomsft_1-1653556892550.png 

Try this and let me know the results.

 

% Pick Entered = DIVIDE(COUNT('tbl_KPIMatrix'[ShipmentCountPickupComplete]),COUNT('tbl_KPIMatrix'[ShipmentCountPickup]))

Best Regards,
Gao

Community Support Team

 

If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly -- How to provide sample data

Whitewater100
Solution Sage
Solution Sage

Hi:

Can you try:

DIVIDE(Sum(tbl_KPIMatrix[ShipmentCountPickupComplete]),CALCULATE(Sum(tbl_KPIMatrix[ShipmentCountPickup])), REMOVEFILERS())

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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

Top Solution Authors