Hello,
I am attaching a sample set of data. Would like to learn what the DAX will be to find the total price. If the price is $0 for any record for a project, the total price should show $0.
In the attached sample, for example, The total price for Project 2 and 4 should be zero and total price for project should be $74.
Appreciate your inputs.
Thank you!