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

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