Forum Discussion
Measure to Return Count - A Number not a ID
Hi Experts
How can i amend the following measure to return a count as opposed to a single Product ID Number eg. (1315525)
Qty_Requested =
CALCULATE (
FIRSTNONBLANK (its_metapack_requested_returns[ordernumber], 1 ),
FILTER ( ALL ( its_metapack_requested_returns), its_metapack_requested_returns[ordernumber] = FACTSalesOrderTable[increment_id])
)
Anonymous ,
Qty_Requested = Try like
CALCULATE (
count(its_metapack_requested_returns[ordernumber]),
FILTER ( ALL ( its_metapack_requested_returns), its_metapack_requested_returns[ordernumber] = FACTSalesOrderTable[increment_id])
)
2 Replies
- amitchandak
Super User
Anonymous ,
Qty_Requested = Try like
CALCULATE (
count(its_metapack_requested_returns[ordernumber]),
FILTER ( ALL ( its_metapack_requested_returns), its_metapack_requested_returns[ordernumber] = FACTSalesOrderTable[increment_id])
)