Distinct Count by 2 criteria from another table

[Anonymous]

Hello,

Please help me understand one thing. Situation: from all database I made new table with 2 unique criteria (distinct by name and month  = Summarize(table1;table1[name];table1[month])) ,
then I wanted count all invoices by criteria name+month ..I got that by function

= COUNTAX(
    FILTER(
        table1;
        table1[name ] = EARLIER(new table[name ]) && table1[month  ] = EARLIER(new table'[month  ])
    );table1[invoice]
)
So far so good.

But I cant get unique invoices values like 'distinctcount'  by two criteria (name+month) in new table, I try insert distinct functions before formula and before invoice criteria, but cant get these distinctcount invoice numbers.

Can someone help me solve that problem?

[Anonymous]

I found it:

Measure = CALCULATE ( DISTINCTCOUNT ( table1[invoice] ); FILTER ( table1; table1[name ]= new table[name ] && table1[month ] = new table[month  ] ) )

[parry2k]

@Anonymous Read this post to get your answer quickly.

https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490