Forum Discussion

Manar's avatar
Manar
Helper 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 expression

 

CountOfClaimPrev = calculate(count(ClaimFactsStag[ClaimNbr]),ClaimFactsStag[PrevReportingPeriod])

But it shows me the same value as current report whe I put it in my table

Please Help

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 )
    )

2 Replies

  • v-chuncz-msft's avatar
    v-chuncz-msft
    Community 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 )
    )