Count where Value >160

[Anonymous]

Emp n	Emp Nam	Value
822	Abc	180
121	b	300
400	C	120
492	D	100
312	E	200
		
		
I want to filter data Value >160 & show the output as 3		

Need help in getting count where value is >160. I want to show this in tile.

Thanks,

Raj

[edhans]

COUNTX works over a table, so COUNTX(table,expression). FILTER() below is returning a table that only has the rows that are over 160, then COUNTX is just counting the employee names in that filtered table.

Measure = 
COUNTX(
    FILTER(
        Data,
        Data[Value] > 160
    ),
    Data[Emp n]
)

[Anonymous]

Hi I need to be more specfic on the details.

Raw Table:

Date	Emp n	Emp Nam	Value		
1/1/2020	822	Abc	60		
2/1/2020	822	Abc	120		
1/1/2020	121	b	150		
2/1/2020	121	b	150		
1/1/2020	400	C	80		
1/2/2020	400	C	40		
1/3/2020	492	D	100		
1/4/2020	312	E	200		
	After removing the Date , the data is aggregated based on the mp name.				
					
	Emp n	Emp Nam	Value		
					
	822	Abc	180		
	121	b	300		
	400	C	120		
	492	D	100		
	312	E	200		
					
					
					
					
					
I want to filter data Value >160 & show the output as 3					

[Ashish_Mathur]

Hi,

Try these measure

Values = SUM(Data[Value])

Count = COUNTROWS(FILTER(SUMMARIZE(Values(Data[Emp n]),Data[Emp n],"ABCD",[Values]),[Values]>160))

Hope this helps.

[edhans · Accepted solution]

Try this:

Measure =
VAR SummaryTable =
    SUMMARIZECOLUMNS(
        'Data 2'[Emp n],
        'Data 2'[Emp Nam],
        "Total Value", SUM( 'Data 2'[Value] )
    )
RETURN
    COUNTX(
        FILTER(
            SummaryTable,
            [Total Value] > 160
        ),
        [Emp n]
    )

If you need additional help please provide data in a valid table. See links below. Text boxes are not good ways to convey tabular data.

How to get good help fast. Help us help you.
How to Get Your Question Answered Quickly
How to provide sample data in the Power BI Forum