Help with Calculation Groups and SELECTEDEMEASURE

[ptmuldoon]

I'm trying to learn more and possibly rework alot of my current measures and model to make better use of calculation groups, and struggleing some with the logic and DAX in setting it up.   Most of my measures use the calculate function.

I created a time intelligence group, and that went pretty easily, things like below.

Last 7 = 
CALCULATE ( 
      SELECTEDMEASURE(),
      DATESINPERIOD ( 'Dim Period'[Date],
        MAX ( 'Dim Period'[Date] ), 
        -7,
        DAY
      )
)

But now I want to also create a unit of measure group for things like QTY, Amount, % of Rev, etc.   Currently, I have an Amt measure that adds up the amount column from 2 tables.   But how do I move that into a calcuation group with SELECTEDMEASURE and SumX?   Or am I overthinking it to much?

How do I use/convert the below to use in a calculation group?

Amt = CALCULATE(
    (Sum(PSDailyExtended[amt]) + Sum(PSMonthlyExtended[amt]))
)

The same would exist for qty, and then various DIVIDE measures to get the % of revenue, etc.

[some_bih · Accepted solution]

Hi @ptmuldoon if you want create calculation group in Power BI, check general link about it.

If you want measures like Sales Amount %  growth and similar to Quantity, check great link to this topic (QTD, YTD...)

[ptmuldoon]

Thanks.

I had already read the first article there, and 2nd is pretty helpful also.  But I think I'm just overthinking things some.  The time intelligence calculation group seems pretty straight forward.  And I think really all I needed (in my instance/model) was to create a field paramter of the different Unit of Measure calcs I have for QTY, Amount, % of Rev, etc, and use that parameter as the measure.

Really just experimenting and learning more.  Everything I have learned is self taught so far, but beginning to to think about the PL300 exam as a next step.