cancel
Showing results for 
Search instead for 
Did you mean: 

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

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 November 2023 Update Carousel

Power BI Monthly Update - November 2023

Check out the November 2023 Power BI update to learn about new features.

Power BI Fabric Summit Carousel

The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors