I was wondering if any one can help me with a couple of DAX formula.
The first is weighted average - from doing some reading I see Sumx being floated as a way to do this.
My model is attached, which is just current base calculations is attached . Effectively I want to be able to calculate the weighted average Price to Book with filters on. The current formula I have seems to work when all the securities are selected but when I use the slicer the P/B add together cumulatively rather than give me a filtered W.A.
The second one is dynamic indexing:
I generally like to index different securities or FX pairs to 100 at a point in time. So in excelCapital Markets Report.pbix (3.7 MB) I would have the current value divided by the first value *100. In the slicer I want to be able to change the date and for the first date of the index to adjust to the first date in a slicer. Does anyone know how to do this?