Qlik Aggr function into Dax

[Anonymous]

Hi Team,

I am looking for equivalent DAX for below qlik expression

 Count(
distinct (If(
Aggr(Count([Tag Number]),[Tag Number],[Asset ID])>1, [Asset ID]
)
)
)

[amitchandak · Accepted solution]

@Anonymous , Try a new measure

measure =

var _tab = summarize(Table, Table[Asset ID], [Tag Number],"_cnt" ,count([Tag Number]) >1)
return
count(summarize(_tab, [Tag Number]),[Tag Number])

[Anonymous]

Hi Amit,
Can you help me to convert below qlik to power bi dax

(Count(DISTINCT if(WildMatch(AGGR(distinct CONCAT(distinct [Group ],','),Progress,Grade,ID),'First'),ID))/Count(DISTINCT{<[Group] = {'First,'NotNotFirst'}>}ID),0)