Individual Measures vs Calculation Groups

DAX DAX Calculations
1

I have a situation where multiple different measures (Gross Sales, Net Sales, Margin) etc all have essentially the same calculation for the branched measures I need in my model; YTD, MTD, SPLY, and so forth. This is clearly a use case for a calculation group.

The examples I have seen demonstrate this using a matrix, and then filtering the displayed columns with a slicer. This is pretty cool. Thing is, I need to pick out some measures as KPIs, so whilst I might want the calculation group “generated” measures in a matrix, I still want some headline figures on cards, for example Margin WTD LY. Is it possible to get individual measure values if you’ve gone down the path of doing it the generic way using SELECTEDMEASURE etc? Or will I still have to define individual specific measures for any I want to pick out on their own?

Thanks!

2

First, I will preface this with the statement that I have not gotten into using calculation groups for anything other than to practice learning how to create them.

With that said, my opinion is that if something is important enough to need a KPI visual, then it’s worth having as a distinct measure on your report.

My feeling is that I would limit calculation groups for things that I really don’t need to pull out separately for a distinct visual.

3 Likes
3

Thanks Heather, I totally agree.

1 Like