Forum Discussion

Dillard70's avatar
Dillard70
Regular Visitor
8 years ago
Solved

Creating Measure that counts rows in column with a specific value and filters by another column

I am trying to create a measure that counts the number of rows in the column "Last FInished Milestone" that equal "Started", but only counts rows that also have a value under the "Credit Score" colum...
Need Help
  • v-jiascu-msft's avatar
    v-jiascu-msft
    8 years ago

    Hi Dillard70,

     

    Try these similar formulas please.

    Started =
CALCULATE (
    COUNTAX ( 'Merged Reports', [Last Finished Milestone] ),
    'Merged Reports'[Last Finished Milestone] = "Started",
    ISBLANK ( 'Merged Reports'[Credit Score] ) = FALSE ()
)

    Started 2 = 
CALCULATE (
    COUNTAX ( 'Merged Reports', [Last Finished Milestone] ),FILTER(all('Merged Reports'),
    'Merged Reports'[Last Finished Milestone] = "Started"&&
    ISBLANK ( 'Merged Reports'[Credit Score] ) = FALSE ()
)
)

    Best Regards,

    Dale

v-jiascu-msft's avatar
v-jiascu-msft
Microsoft Employee
8 years ago

Hi Dillard70,

 

Try these similar formulas please.

Started =
CALCULATE (
    COUNTAX ( 'Merged Reports', [Last Finished Milestone] ),
    'Merged Reports'[Last Finished Milestone] = "Started",
    ISBLANK ( 'Merged Reports'[Credit Score] ) = FALSE ()
)

Started 2 = 
CALCULATE (
    COUNTAX ( 'Merged Reports', [Last Finished Milestone] ),FILTER(all('Merged Reports'),
    'Merged Reports'[Last Finished Milestone] = "Started"&&
    ISBLANK ( 'Merged Reports'[Credit Score] ) = FALSE ()
)
)

Best Regards,

Dale

Dillard70's avatar
Dillard70
Regular Visitor
8 years ago

Thank you Dale, that works perfectly!