Forum Discussion

MrMichael's avatar
MrMichael
Frequent Visitor
4 years ago
Solved

Remove Variable filter context

Hi,    I am calculating earned premium up till a specific date using the variable "LatestReportingDate". However, when using this variable, the filter context "YOA <= 2020" is kept.  Earned =...
  • tamerj1's avatar
    tamerj1
    4 years ago

    Hi MrMichael 
    The LatestReportingDate will return the last available date in in current filter context only if the year is 2020 or less. In the case of the year 2021 it will return blank. In this case the measure will also return blank as there is no blank date in your table. 
    You can FILTER ( ALL ( Table ), ..... in both measures but the best way to achieve what you need is the have a date table.

SpartaBI's avatar
SpartaBI
Icon for Community Champion rankCommunity Champion
4 years ago

MrMichael try this:

 

Earned =
VAR LatestReportingDate =
    CALCULATE (
        MAX ( TABLE[ReportingPeriodStartDate] ),
        TABLE[YOA] <= 2020
    )
RETURN
    CALCULATE (
        SUM ( TABLE[EarnedPremium] ),
        TABLE[ReportingPeriodStartDate] = LatestReportingDate
    )

 




In case it answered your question, please accept the solution to help other members find it. Appreciate Your Kudos.


SpartaBI Logo

Visit SpartaBI website   Visit SpartaBI Linkdin   Visit SpartaBI Facebook

Showcase Report – Contoso By SpartaBI