Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Count values that match criteria

Hey guys, I need some help trying to count how many times that multiple condition occur based upon a distinct count. e.g.   Invoice | Charge Type 123 | Basic 123 | Intermediate 124 | Basic 124...
Need Help
  • ChandeepChhabra's avatar
    ChandeepChhabra
    7 years ago

    I am assuming when you say "blanks" you mean the Charge type being blank? Try this measure

     

    Invoices with 3 Charges =
COUNTROWS (
    FILTER (
        VALUES ( Table1[Invoice ] ),
        CALCULATE (
            COUNTROWS (
                CALCULATETABLE (
                    VALUES ( Table1[Charge Type] ),
                    Table1[Charge Type] <> BLANK ()
                )
            )
        ) = 3
    )
)
Ashish_Mathur's avatar
Ashish_Mathur
Icon for Super User rankSuper User
7 years ago

Hi,

This measure will count the number of invoices where the the Charge Type is =3.  The answer is 1.

Measure = COUNTROWS(FILTER(SUMMARIZE(VALUES(Data[Invoice]),[Invoice],"ABCD",DISTINCTCOUNT(Data[Charge Type])),[ABCD]=3))

Hope this helps.