Forum Discussion

morgtd30's avatar
morgtd30
Icon for Helper I rankHelper I
6 years ago
Solved

Help with filtering out measure

I have a slicer option that is "6/1/2020". When de-selected I need it to turn both measures blank. JunProj = CALCULATE(SUM(Projections[Amount]), Projections[Month] = "6/1/2020") I have another ...
Need Help
  • morgtd30's avatar
    morgtd30
    6 years ago

    I was able to solve the problem with the following formula:

    Apr Projection =
    TOTALYTD([AprProj], 'Date'[Date])
    +
    IF(
    COUNTROWS(
    FILTER(
    MonthTable,
    MonthTable[ProjectionMonth] = "4/1/2020")
    ) >0,

    TOTALYTD(CALCULATE(SUM(Opportunity[Amount]),Opportunity[StageName] = "Closed Won",Opportunity[CloseDate] < DATE(2020,4,1)) , 'Date'[Date]),BLANK()
    )
morgtd30's avatar
morgtd30
Icon for Helper I rankHelper I
6 years ago

Also to be clear it's June 20 that is still displaying data:

 

morgtd30's avatar
morgtd30
Icon for Helper I rankHelper I
6 years ago

I was able to solve the problem with the following formula:

Apr Projection =
TOTALYTD([AprProj], 'Date'[Date])
+
IF(
COUNTROWS(
FILTER(
MonthTable,
MonthTable[ProjectionMonth] = "4/1/2020")
) >0,

TOTALYTD(CALCULATE(SUM(Opportunity[Amount]),Opportunity[StageName] = "Closed Won",Opportunity[CloseDate] < DATE(2020,4,1)) , 'Date'[Date]),BLANK()
)