Forum Discussion
Solved
Count selected rows based on filtered value
Hi, I need to count the number of distict app_no where app_status is "live" and "new". As an example, for app_no (235) I have 2 rows of data as row one has app_status = Live and row 2 has an ap...
Hey M_SBS_6
Not sure how you want to us the count output, but you can use this:
Distict app_no =VAR _A =FILTER (SUMMARIZE (FILTER ( 'Table', 'Table'[App_staus] = "Live" || 'Table'[App_staus] = "New" ),[App_no],"C", COUNTROWS ( 'Table' )),[C] > 1)VAR _B =COUNTROWS ( _A )RETURN
Hey M_SBS_6
Not sure how you want to us the count output, but you can use this:
Distict app_no =
VAR _A =
FILTER (
SUMMARIZE (
FILTER ( 'Table', 'Table'[App_staus] = "Live" || 'Table'[App_staus] = "New" ),
[App_no],
"C", COUNTROWS ( 'Table' )
),
[C] > 1
)
VAR _B =
COUNTROWS ( _A )
RETURN