Apologies if this has been asked previously - as I am new to DAX and haven't quite found what I'm looking for.
Goal: To have a dynamic measure that calculates the annualized spend based on a months slicer across all categories.
For example, say that I have the following data:
I would like to summarize it in a table and add a measure that calculates the annualized spend (e.g., the average of all the bananas for the first four months multiplied by 12 to get the annualized average. Or, something like this:
Additionally, I would love for it to be dynamic (the annualized spend is based on slicer). So, if I have three months selected and am showing totals by category for three months, the formula might look like [(Sum of all bananas Jan - Mar)/*3 months] * 12 months.
I have been experimenting with SELECTEDVALUE and SUMX but haven't quite figured it out yet.
Thank you so much in advance!