cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

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])
)
1 ACCEPTED SOLUTION
amitchandak
Super User
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])
)

View solution in original post

2 REPLIES 2
amitchandak
Super User
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])
)

Anonymous
Not applicable

thanks Amit

Helpful resources

Announcements
PBI Sept Update Carousel

Power BI September 2023 Update

Take a look at the September 2023 Power BI update to learn more.

Learn Live

Learn Live: Event Series

Join Microsoft Reactor and learn from developers.

Top Solution Authors