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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

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
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

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

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.