Forum Discussion

kchan002's avatar
kchan002
Frequent Visitor
8 years ago
Solved

measure summary

I have created a MEASURE which I am using on a Matrix table sorted by Sales Reps & Date:    # Deals = calculate(COUNTROWS('Opportunity'), FILTER('Opportunity','Opportunity'[Omit__c] = FALSE()), F...
v-huizhn-msft's avatar
v-huizhn-msft
Icon for Microsoft Employee rankMicrosoft Employee
8 years ago

Hi kchan002,

Please add 0 in your formula as follows and check if ot works fine.

Deals = calculate(COUNTROWS('Opportunity'),
FILTER('Opportunity','Opportunity'[Omit__c] = FALSE()),
FILTER('Opportunity','Opportunity'[ForecastCategory] <> "Omitted"),
FILTER('Opportunity','Opportunity'[StageName] <> "Closed Won"),
FILTER('Opportunity', 'Opportunity'[First_Day_Close_Date__c] = sum(Quota[Month_Year__c])))+0


Best Regards,
Angelia

kchan002's avatar
kchan002
Frequent Visitor
8 years ago

Hi, 

 

It seems that it takes care of the null values and places a "0".

However, the Total still says 0.

 

                             Deals

Sales Rep 1             10

Sales Rep 2              0

Sales Rep 3              0

                                0

  • Zubair_Muhammad's avatar
    Zubair_Muhammad
    Icon for Community Champion rankCommunity Champion
    8 years ago

    kchan002

     

    Try adding this MEASURE.

     

     

    DealsWithTotal =
IF (
    HASONEVALUE ( TableName[Name_c] ),
    [# Deals],
    SUMX ( ALLSELECTED ( TableName[Name_c] ), [# Deals] )
)
    • kchan002's avatar
      kchan002
      Frequent Visitor
      8 years ago

      Now, it adds the columns (I can see the total at the bottom of the table).

      But, it doesn't add the rows:

       

                                   January       February      March....      Total

      Sales Rep 1              1                  0                  0                 0

       

      Thanks!