Forum Discussion

trk26's avatar
trk26
Frequent Visitor
5 years ago

Cost per Unit Measure

Hello - I would like to create a measure that calculates the line item amount per Truckwashes sold for each month and have struggled to .  The line item measure is: Net Amt = CALCULATE(SUM('erbPos...
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
5 years ago

trk26 , Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

 

Try like

 

Net Amt for Truckwashes Sold =
CALCULATE(
[Net Amt],
filter('erbPostedTrxv2', 'erbPostedTrxv2'[Line Item] IN { "Truckwashes Sold" })
)