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.
select AVG (Salary) ,title from Employee
Group By title
having AVG(Salary)>25000
this query i would like to implement in DAX measure.
not on drag n drop with Average function
Solved! Go to Solution.
Hi @Anonymous,
Please refer to below formula to create a calculated table:
Filter Table = FILTER ( SUMMARIZE ( Employee, Employee[Title], "Average salary", AVERAGE ( Employee[Salary] ) ), [Average salary] > 25000 )
Regards,
Yuliana Gu
Hey @Anonymous,
You can create a measure using the following format:
Average Salary = CALCULATE(AVERAGE([Column]), FILTER(ALL('Table'[Column]), [Column] > 25000)
Hope this helps,
Alan
this is not working,
it is bringing all the Title even though there is no match.
Hi @Anonymous,
Please refer to below formula to create a calculated table:
Filter Table = FILTER ( SUMMARIZE ( Employee, Employee[Title], "Average salary", AVERAGE ( Employee[Salary] ) ), [Average salary] > 25000 )
Regards,
Yuliana Gu
EVALUATE Filter Table = FILTER ( SUMMARIZE ( Employee, Employee[Title], "Average salary", AVERAGE ( Employee[Salary] ) ), [Average salary] > 25000 )ORDER BY "Average Salary"
Can i make use of ORDER BY for this in POWER BI its is not accepting syntax
Thanks Yulugu,
so can't we write a measure for this instead of calculated table.
Covering 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 |
---|---|
113 | |
100 | |
78 | |
76 | |
52 |
User | Count |
---|---|
146 | |
109 | |
106 | |
88 | |
61 |