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

2 Replies

  • amitchandak's avatar
    amitchandak
    Super 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)