I was trying to get the sum of the bottom 20% values, then show it by year. However, the DAX returned the total value.
Bottom 20% Values =
VAR BV = ROUND(COUNTROWS(Sheet1) * 0.2,0)
VAR DR = RANKX(ALL(Sheet1),CALCULATE(SUM(Sheet1[Value])),,DESC,Skip)
RETURN
IF(DR <= BV...