Forum Discussion

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

Quarterly Count with multiple filters

Hi, I want to create a measure to show quarterly count of records with multiple filters. The data table is like below, For this example, the result (record count) should be = 4 I tried bel...
Need Help
Show and Tell
Tips and Tricks
  • StevenGrenier's avatar
    StevenGrenier
    6 years ago

    The syntax for CALCULATE is CALCULATE([expression], filter, filter, filter...). You are trying to add multiple filters in the same FILTER statement by using &&. Simply add more FILTER statements and it should work.

     

    CustomMeasure = CALCULATE(DISTINCTCOUNT('VW_Water'[CC_MASTER__ID]), FILTER('VW_Water','VW_Water'[CC_MAST_SUBTYPE]= "E*LEAK"), FILTER('VW_Water','VW_Water'[EarlyClosure]= "Double up"), FILTER('VW_Water','VW_Water'[Activity]= "Complete"))

     

    Hope this helps!

StevenGrenier's avatar
StevenGrenier
Frequent Visitor
6 years ago

The syntax for CALCULATE is CALCULATE([expression], filter, filter, filter...). You are trying to add multiple filters in the same FILTER statement by using &&. Simply add more FILTER statements and it should work.

 

CustomMeasure = CALCULATE(DISTINCTCOUNT('VW_Water'[CC_MASTER__ID]), FILTER('VW_Water','VW_Water'[CC_MAST_SUBTYPE]= "E*LEAK"), FILTER('VW_Water','VW_Water'[EarlyClosure]= "Double up"), FILTER('VW_Water','VW_Water'[Activity]= "Complete"))

 

Hope this helps!

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    6 years ago

    StevenGrenier 

    Try

    CustomMeasure = CALCULATE(DISTINCTCOUNT('VW_Water'[CC_MASTER__ID]), FILTER('VW_Water','VW_Water'[CC_MAST_SUBTYPE]= "E*LEAK" && 'VW_Water'[EarlyClosure]= "Double up" && 'VW_Water'[Activity]= "Complete"))

CustomMeasure = CALCULATE(DISTINCTCOUNT('VW_Water'[CC_MASTER__ID]),'VW_Water'[CC_MAST_SUBTYPE]= "E*LEAK", 'VW_Water'[EarlyClosure]= "Double up",'VW_Water'[Activity]= "Complete")

    if you need more help make me @

    Appreciate your Kudos.

  • chinthada's avatar
    chinthada
    Icon for Helper I rankHelper I
    6 years ago

    Thanks StevenGrenier 

    As suggested adding more FILTER statements has done the trick!