Forum Discussion

CarlBlunck's avatar
CarlBlunck
Icon for Resolver I rankResolver I
2 years ago
Solved

Calculate with not equal to filter issue

Hi team,   I have this measure:   PerformanceReview_Total = CALCULATE(     DISTINCTCOUNT(fact_PerformanceReview[Person Person No.]),     fact_PlacementData[PersonStatus] = "Existing",     fa...
Need Help
  • parry2k's avatar
    parry2k
    2 years ago

    CarlBlunck I just answered the similar question, update your measure to this:

     

    PerformanceReview_Total = CALCULATE(
    DISTINCTCOUNT(fact_PerformanceReview[Person Person No.]),
    KEEPFILTERS ( fact_PlacementData[PersonStatus] = "Existing" ),
    KEEPFILTERS ( fact_PlacementData[BaseClass] <> "UNPAID" )
)

     

    To learn more about keepfilters, check this video on my YT channel:

     

parry2k's avatar
parry2k
Icon for Super User rankSuper User
2 years ago

CarlBlunck I just answered the similar question, update your measure to this:

 

PerformanceReview_Total = CALCULATE(
    DISTINCTCOUNT(fact_PerformanceReview[Person Person No.]),
    KEEPFILTERS ( fact_PlacementData[PersonStatus] = "Existing" ),
    KEEPFILTERS ( fact_PlacementData[BaseClass] <> "UNPAID" )
)

 

To learn more about keepfilters, check this video on my YT channel:

 

CarlBlunck's avatar
CarlBlunck
Icon for Resolver I rankResolver I
2 years ago

Thanks parry2k !  Did something change lately to require the keepfilters() function to be included?