Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago

*Deleted

Need Help

1 Reply

  • v-yulgu-msft's avatar
    v-yulgu-msft
    Microsoft Employee
    8 years ago

    Hi Anonymous,

     

    That case, you can apply a filter in [Written Unit Plan] calculation.

    Written Unit Plan =
CALCULATE (
    SUM ( SP_MetricPlan[Plan] ),
    FILTER (
        SP_MatricPlan,
        SP_MatricPlan[Month] = "April"
            && ( SP_MatricPlan[Metric] = "Written Units, multi props incl"
            || SP_MatricPlan[Metric] = "Written Units"
            || SP_MatricPlan[Metric] = "Units" )
    )
)

    Regards,

    Yuliana Gu