Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

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_requeste...
Need Help
  • amitchandak's avatar
    amitchandak
    5 years ago

    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])
    )

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
5 years ago

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])
)

Anonymous's avatar
Anonymous
Not applicable
5 years ago

thanks Amit