calcul the sum with criteria

[Orange2045]

Dear all,

I would like to construct a report as below format

my date base is 

may i ask you help to know what DAX i can use to get the amounts by different criteres? 

I used to use filter to obtain all the information i need and then extract to excel to calculate. but it is not pratical. 

Thanks for your help, 

Annie

[Orange2045]

Thank you 😀

[AbbasG · Accepted solution]

@Orange2045  refer to the post below, it will help you achieve your desired output.


https://community.powerbi.com/t5/Desktop/Create-a-SUM-measure-that-sums-conditionally-based-on-a-val...