PBI Dax calculation

You need to include a call to REMOVEFILTERS inside the CALCULATE statement. This should apply to the column in have grouped in rows in the visual. What column is that?

Supposing it is Sales[order_date],

CALCULATE (
         [Total Profit],

         REMOVEFILTERS ( Sales[order_date] ),
         YEAR ( Sales[order_date] )=2013
)

PS you should use a calendar table and the removefilters would not be needed 🙂

If this helped, please consider giving kudos and mark as a solution

me in replies or I'll lose your thread

Want to check your DAX skills? Answer my biweekly DAX challenges on the kubisco Linkedin page

Consider voting this Power BI idea

Francesco Bergamaschi

MBA, M.Eng, M.Econ, Professor of BI