Forum Discussion
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 to show this in tile.
Thanks,
Raj
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
4 Replies
- edhans
Community Champion
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] )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- edhans
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