Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Count and Sum

Hi All,  Consider below table as example    Consider below table  Project ID Met Not Met Grand Total Condition = If (Met = Grand Total), 1,0) 10030-01 2   2 1 10077-03 5   5 ...
Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    HI Anonymous,

    You can try to use the following measure formulas if it suitable for your requirement:

    Measure =
VAR summary =
    SUMMARIZE (
        ALLSELECTED ( 'Table' ),
        [Project ID],
        "Met", CALCULATE ( COUNTROWS ( 'Table' ), 'Table'[Met/NotMet] = "Met" ),
        "Total", COUNTROWS ( 'Table' )
    )
RETURN
    COUNTROWS ( FILTER ( summary, [Met] = [Total] ) )

    Regards,

    Xiaoxin Sheng

Tahreem24's avatar
Tahreem24
Icon for Super User rankSuper User
4 years ago

Anonymous , Try this steps:

Step 1: First Create a Measure for Met and likewise for NotMet:

Met Measure = Caluculate(COUNTROWS(TableName),FILTER(TableName,TableName[Met/NotMet Column]="Met")

 

Step 2: Likewise create for NotMet. Measure.

 

Step 3: Create Measure for Grand Total.

Grand Total Measure= COUNTROWS(TableName)

 

Step 4: Create a Measure like below:

Measure = CALCULATE(COUNTROWS(TableName),FILTER(TableName,[Met Measure]=[Grand Tota Measure]))+0
 
 

 

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi 

I want distinct count of project id than rows

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    HI Anonymous,

    You can try to use the following measure formulas if it suitable for your requirement:

    Measure =
VAR summary =
    SUMMARIZE (
        ALLSELECTED ( 'Table' ),
        [Project ID],
        "Met", CALCULATE ( COUNTROWS ( 'Table' ), 'Table'[Met/NotMet] = "Met" ),
        "Total", COUNTROWS ( 'Table' )
    )
RETURN
    COUNTROWS ( FILTER ( summary, [Met] = [Total] ) )

    Regards,

    Xiaoxin Sheng