Forum Discussion

TomSinAA's avatar
TomSinAA
Icon for Helper IV rankHelper IV
4 years ago

% 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...
%
Need Help DAX
Whitewater100's avatar
Whitewater100
Icon for Solution Sage rankSolution Sage
4 years ago

Hi:

Can you try:

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