SUMX and Filter

[HenryJS]

Hi all,

How do I add a filter to the below sumx function?

I want to add a filter where 'Export Candidates'[Preferred Role] is Foreman

Total Candidates in 25km = sumx('Export Candidates',[In25k])

Thanks,

Henry

[amitchandak]

In place of table you can have the filter

sumx(filter('Export Candidates',<Condition>),[In25k])

more

calculate(sumx(filter('Export Candidates',<Condition>),[In25k]),<condition or filter>)

Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution.
In case it does not help, please provide additional information and mark me with @
Thanks. My Recent Blogs -Decoding Direct Query - Time Intelligence, Winner Coloring on MAP, HR Analytics, Power BI Working with Non-Standard TimeAnd Comparing Data Across Date Ranges
Proud to be a Datanaut Connect on Linkedin

[HenryJS]

Is this correct?

Total Candidates in 25km = sumx(filter('Export Candidates', 'Export Candidates'[PreferredRole] in {"Foreman"}),[In25k])

[amitchandak · Accepted solution]

Seems fine. Unless ln25k is not working with 'Export Candidates'. What error is it giving?