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

ArulselvanD07's avatar
ArulselvanD07
Helper I
8 years ago

Could you please share the Data and the result you are looking for? Also share the relationship details for your datasets [can be found on the relationships tab