08-31-2016 12:12 AM
I am showing the trend of 3 measure values for last 12 months, but user want to know the % of last current month data as well.
Then I used below DAX functions which helped me not to write one more sql code.
CALCULATE(SUM('Total Open'[Opened]) ,FILTER(ALL('Total Open'[Month]), 'Total Open'[Month] = MAX ('Total Open'[Month])) )
I used this code for all 3 measure seperately and then use "100% Stacked Column Chart" to display.