Tuesday, 1 July 2025

Multiply & divide with One column & one measure

  • Below [RCTQTY] is a column & [Sampling Measure] is a measure
Expected Uploads Measure1 =
SUMX(
    Receipts_SAP,
    Receipts_SAP[RCTQTY] * [Sampling Measure]
)

  • Below [SN_Count] is a column & [Expected Uploads Measure1] is a measure
Upload Percentage =
DIVIDE(SUM(Receipts_LSQD[SN_Count]), [Expected Uploads Measure1])




No comments:

Post a Comment