Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

Question about Prior Month Measure against custom measure using distinctcount

I have a measure I created: Total Staff = var _table=SUMMARIZE('All_NICE_Data','All_NICE_Data'[Agent Name],'Calendar Dates'[Date],"distinctcount",DISTINCTCOUNT('All_NICE_Data'[Agent Name])) return...
@measure
@Power BI
@power bi desktop
  • lbendlin's avatar
    lbendlin
    2 years ago

    You cannot measure a measure.  Use it directly.

     

    Previous Month Staff =
    CALCULATE(
       [Total Staff]   ,
        DATEADD(
            'Calendar Dates'[Date],
            -1,
            MONTH
        )
    )
lbendlin's avatar
lbendlin
Super User
2 years ago

You cannot measure a measure.  Use it directly.

 

Previous Month Staff =
CALCULATE(
   [Total Staff]   ,
    DATEADD(
        'Calendar Dates'[Date],
        -1,
        MONTH
    )
)