Havinng Clause implement in DAX

[Anonymous]

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

[alanhodgson]

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

[Anonymous]

this is not working,

it is bringing all the Title even though there is no match.

[v-yulgu-msft · Accepted 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

[Anonymous]

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

[Anonymous]

Thanks Yulugu,

so can't we write a measure for this instead of calculated table.