Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.
Hi Experts
How can i amend the following measure to return a count as opposed to a single Product ID Number eg. (1315525)
Solved! Go to Solution.
@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 ,
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])
)
thanks Amit
Check out the November 2023 Power BI update to learn about new features.
Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.