Count where Value >160

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...

Need Help

edhans
6 years ago
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

Anonymous

Not applicable

6 years ago

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

Super User

6 years ago

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.

Forum Discussion

Count where Value >160