Forum Discussion
% 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 Ent...
Hi:
Can you try:
DIVIDE(Sum(tbl_KPIMatrix[ShipmentCountPickupComplete]),CALCULATE(Sum(tbl_KPIMatrix[ShipmentCountPickup])), REMOVEFILERS())