formula on power query

[Domingos]

Hi comunity,

How do I rewrite the following formula created on Data view in power query ?

Nº de CM por RO = CALCULATE(COUNTA(Planeamento[Consulta de mercado]),

FILTER('Estados_Uniques','Estados_Uniques'[Consulta de mercado]='Estados_Uniques'[Consulta de mercado]))

Thanks

[AjithPrasath · Accepted solution]

@Domingos ,

  Hi, Please use the below code in custom column:

Nº de CM por RO = 
let
    consultaDeMercado = [Consulta de mercado],
    estadosUniques = Table.SelectRows(Estados_Uniques, each [Consulta de mercado] = consultaDeMercado),
    count = Table.RowCount(estadosUniques)
in
    count

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

[Mahesh0016]

@Domingos I don't know its helps you or not but you can Try group by in power query.THANK YOU!!