Forum Discussion

Manar's avatar
Manar
Icon for Helper II rankHelper II
8 years ago
Solved

ask question

 Hi, I am trying to count claims by reporting period (want to compare between current and last period), I have a column Current Reporting Period and Prev Reporting Period, I wrote the following expr...
Need Help
  • v-chuncz-msft's avatar
    v-chuncz-msft
    8 years ago

    Manar,

     

    You may refer to measure below.

    Measure =
VAR prev =
    SELECTEDVALUE ( ClaimFactsStag[PrevReportingPeriod] )
RETURN
    CALCULATE (
        COUNT ( ClaimFactsStag[ClaimNbr] ),
        ClaimFactsStag[ReportingPeriod] = prev,
        ALLSELECTED ( ClaimFactsStag )
    )
v-chuncz-msft's avatar
v-chuncz-msft
Icon for Community Support rankCommunity Support
8 years ago

Manar,

 

You may refer to measure below.

Measure =
VAR prev =
    SELECTEDVALUE ( ClaimFactsStag[PrevReportingPeriod] )
RETURN
    CALCULATE (
        COUNT ( ClaimFactsStag[ClaimNbr] ),
        ClaimFactsStag[ReportingPeriod] = prev,
        ALLSELECTED ( ClaimFactsStag )
    )