Forum Discussion

JimJim's avatar
JimJim
Responsive Resident
4 years ago
Solved

Calculation Groups

Hi Guys,

I have multiple measures and the business have asked me to show the same measures as a rolling 3 month number.

Here is one measure I have:

Order Count = 
    DISTINCTCOUNT(orders[order_number])

Here is the R3M equivalent (based on fiscal calendar):

Order Count R3M = 
VAR __lastVisibleDate =
    LASTDATE ( 'Time'[Date] )
VAR __financialPeriod =
    MIN ( 'Time'[YearMonthKey] ) - 2
VAR __fromDate =
    CALCULATE (
        FIRSTDATE ( 'Time'[Date] ),
        FILTER ( ALL ( 'Time' ), 'Time'[YearMonthKey] = __financialPeriod )
    )
VAR __canMove3MBack =
    NOT ISBLANK ( DATEADD ( __lastVisibleDate, -2, MONTH ) )
VAR __result =
    CALCULATE (
        [Order Count],
        DATESBETWEEN('Time'[Date], __fromDate, __lastVisibleDate)
    )
RETURN
    IF ( __canMove3MBack, __result )

I would like to add the DAX from the R3M into a calculation group and reuse it but because my calculation is in a variable (__result) I don't know how. Is this possible?

  • JimJim,

     

    In the calculation item (within the calculation group), replace [Order Count] with SELECTEDMEASURE(). This will make it dynamic for whatever measure is in the visual.

     

     

1 Reply

  • JimJim,

     

    In the calculation item (within the calculation group), replace [Order Count] with SELECTEDMEASURE(). This will make it dynamic for whatever measure is in the visual.