Forum Discussion

AdmanPowerBI's avatar
AdmanPowerBI
Frequent Visitor
6 years ago
Solved

Multiple Filters with SUMX

Hi There,   I hope that I have described this correctly but here it goes:   I'm working on a solution to find previous year-to-date and I found that Kasper On BI had a great solution. I have a ne...
Need Help
AdmanPowerBI's avatar
AdmanPowerBI
Frequent Visitor
6 years ago

Hi calerof ,

 

Thank you very much! That worked 🙂

I can honestly say I'm not quite sure why and if you have time, I would love to know. Again thanks so much.

 

Adam

  • calerof's avatar
    calerof
    Impactful Individual
    6 years ago

    Hi AdmanPowerBI ,

     

    First and foremost, if you review the pbix file, a Calendar table was added to the model and marked as Date Table.

     

    Then, in the Order Value measure I used an explicit measure to sum the line item price, instead of using the implicit measure LineItemPrice.

     

    Lastly, in the Sales Same Period measure I used the Order Value measure in the RETURN calculation, instead of SUM ( Sales[sales] ).

     

    That was pretty much it.

     

    Best regards,

     

    Fernando

     

    • AdmanPowerBI's avatar
      AdmanPowerBI
      Frequent Visitor
      6 years ago

      Again thank you!