How to create measure for GROUP BY ?

[Anonymous]

Hi!

i want create measure, but this code throws errors

Measure =
var tb = GROUPBY(MainTable;ExchangeAct[EMail];"Cnt";SUMX(currentGroup(); MainTable[ExchangeAct_0]))
return CALCULATE(COUNT('tb'[ExchangeAct_EMail]);FILTER(tb; 'tb'[Cnt] = 0 ))

[v-diye-msft]

Hi @Anonymous 

If you've fixed the issue on your own please kindly share your solution. if the above posts help, please kindly mark it as a solution to help others find it more quickly.thanks!

If the above posts not help, you might consider providing the dummy pbix. 

[amitchandak · Accepted solution]

@Anonymous ,

Try like

countx(filter(summarize(MainTable;ExchangeAct[EMail];"Cnt";SUM(MainTable[ExchangeAct_0])),[Cnt] = 0),[ExchangeAct_EMail])

[Anonymous]

it work! Thanks!

[camargos88]

Hi @Anonymous ,

Try applying a function like COUNTX/SUMX;MAXX..., first you need to reference a table, after that the column.

Ricardo