PowerPivot - New measure - calculate based on two criteria

[tbablue]

Hi Forum,

Quite straightforward I'm sure - but I'm new to measures in PowerPivot.

I have three columns; Definitive Name, Yr.Mnth & Employee FTE. The table name is 'Summary Query'.

I need a measure that will calculate Employee FTE based on the number of times that 'Definitive Name' appears in 'Yr.Mnth'.

In Excel it would be something like...

=SUMIFS([Employee FTE],[Yr.Mnth],[@[Yr.Mnth]],[Definitive Name],[@[Definitive Name]])/COUNTIFS([Yr.Mnth],[@[Yr.Mnth]],[Definitive Name],[@[Definitive Name]])


Any help would be gratefully rec'd.

 

[mart37]

SumIfs:=CALCULATE(SUM([Employee FTE]),FILTER(SummaryQuery,SummaryQuery[Definitive Name]=[Definitive Name]&&SummaryQuery[Yr.Mnth]=SummaryQuery[Yr.Mnth]))
CountIfs:=CALCULATE(COUNTROWS(SummaryQuery),FILTER(SummaryQuery,SummaryQuery[Definitive Name]=SummaryQuery[Definitive Name]&&SummaryQuery[Yr.Mnth]=SummaryQuery[Yr.Mnth]))

 

[tbablue]

SumIfs:=CALCULATE(SUM([Employee FTE]),FILTER(SummaryQuery,SummaryQuery[Definitive Name]=[Definitive Name]&&SummaryQuery[Yr.Mnth]=SummaryQuery[Yr.Mnth]))
CountIfs:=CALCULATE(COUNTROWS(SummaryQuery),FILTER(SummaryQuery,SummaryQuery[Definitive Name]=SummaryQuery[Definitive Name]&&SummaryQuery[Yr.Mnth]=SummaryQuery[Yr.Mnth]))

Really grateful for your time and attention....

A small amount of tidying up the text (mostly spaces and apostrophes) appears to have answered the exam question ...you've saved my sanity!! TY!!

=CALCULATE(SUM([Employee FTE]),FILTER('Summary Query','Summary Query'[Definitive Name]=[Definitive Name]&&'Summary Query'[Yr.Mnth]='Summary Query'[Yr.Mnth]))/CALCULATE(COUNTROWS('Summary Query'),FILTER('Summary Query','Summary Query'[Definitive Name]='Summary Query'[Definitive Name]&&'Summary Query'[Yr.Mnth]='Summary Query'[Yr.Mnth]))

Quick supplemental question: I've never come across a double ampersand - is that the convention for joining multiple criteria?

I'll mark the answer you've supplied as a working solution.