Forum Discussion
DAX Calculated column to sum a matrix column
I have a matrix report with [Rooms] in rows, [Program] in the pivot column, and [AreaM] for the value. I have slicers to change the number of columns displayed [Programs] . I want to filter out ...
Anonymous Calculated columns are only calculated at data load and thus are not interactive. You would need something like a measure.
Thanks, Greg_Deckler . I am making this more complicated than necessary. This simple measure fixed my issue:
_NoProgAreas = (sum('SharepointALL'[AreaM]))
Greg_Deckler
Community Champion
Community ChampionAnonymous Calculated columns are only calculated at data load and thus are not interactive. You would need something like a measure.