Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Sum using conditions

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

Need Help
Show and Tell

2 Replies

  • alexei7's avatar
    alexei7
    Continued Contributor
    8 years ago

    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's avatar
      Anonymous
      Not applicable
      8 years ago

      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. :)