Sum using conditions

[Anonymous]

Hi, I have 5 columns with Date, Week no, Sales Channel, Website and Values. 

PPC Last WTD Spend = CALCULATE(SUM('ALL_WTD'[Value]),'ALL_WTD'[WTD]="Last WTD", 'ALL_WTD'[Funnel]="Spend", 'ALL_WTD'[Channel]="PPC")

But I am getting incorrect sum of spend. 

Apologies if it's a too simple question. 

Many thanks

[alexei7]

Hi,

Would you be able to post some of your data (or make some up if it's sensitive/confidential) so that we can help, along with what your expected result would be?

Thanks

Alex

[Anonymous]

Hi Alex, 

Many thanks. I will send the data next week when I am back. I am trying to switch from tableau to power bi but I think I need to work on my DAX quite a bit before I build something useful for the cheifs at work. have a nice weekend. 🙂