Hello everyone. I am very inexperienced in DAX so the solution to my problem is probably simple, but I am having a hard time understanding DAX, primarily measures, the caculate & filter functions. I come from an Excel background and just don't seem to get it yet.
I have two tables in PowerPivot. Both tables have related columns [SO#] & [PriceType], but I am unable to just link the tables due to many-to-many relationships. I am attempting to create an explicit measure summarizing the net sales quantities column in my 2nd table based upon the filers applied to my first table. If I were just using Excel, SUMIFS would do the trick. I have tried several different formulas, but my pivot table results just end up totaling all of the net sales quantities in every row of my pivot table report. Please see the formula below. Any help would be greatly appreciated.