Cost associated with DAX Measure

[jessetaylor89]

I created a measure to calculate how many events took longer than 90 minutes. Now I want to see what is the total cost of those events. When I add cost its showing me the total cost for all events. 

[tamerj1 · Accepted solution]

Hi @jessetaylor89 

please try

Cost > 90 =
SUMX (
FILTER ( RoadsideInfo, RoadsideInfo[EventDuration] > 90 ),
RoadsideInfo[InvoiceCharges]
)

[jessetaylor89]

If I want to look at charges from April - current date. how do I add that to the dax measure

[jessetaylor89]

Thank you