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()
    )
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
6 years ago

morgtd30 , use is filtered 

if(ISFILTERED('Jun'[slicer]),[junproj],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()
    )