Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Qlik Aggr function into Dax

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's avatar
    amitchandak
    4 years ago

    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])

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
4 years ago

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's avatar
    Anonymous
    Not applicable
    3 years ago

    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)