Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to 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
DAX is for Analysis. Power Query is for Data Modeling
Proud to be a Super User!
MCSA: BI Reporting
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]
)
DAX is for Analysis. Power Query is for Data Modeling
Proud to be a Super User!
MCSA: BI ReportingHi 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
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.
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
DAX is for Analysis. Power Query is for Data Modeling
Proud to be a Super User!
MCSA: BI ReportingCovering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
95 | |
76 | |
65 | |
51 |
User | Count |
---|---|
146 | |
109 | |
106 | |
88 | |
61 |