ask question

[Manar]

 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

[v-chuncz-msft · Accepted solution]

@Manar,

You may refer to measure below.

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

[Manar]

@v-chuncz-msft it worked Thank you!!