Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Dax Calculation for distinct Values

Hi I am looking to achieve below  output . Can someone help on how to do this in DAX.   Account Interaction Type 1 call 1 inperson 2 call 3 inperson 3 call 3 msg   ...
Need Help
  • amitchandak's avatar
    amitchandak
    5 years ago

    Anonymous ,

    only Call =
    countx(filter(summarize(Table, Table[Account], "_1", count(Table[Interaction Type])
    , "_2",calculate(count(Table[Interaction Type]), filter(Table, Table[Interaction Type]= "Call"))),
    [_1] =[_2]) ,[Account] )

     

    only inperson=
    countx(filter(summarize(Table, Table[Account], "_1", count(Table[Interaction Type])
    , "_2",calculate(count(Table[Interaction Type]), filter(Table, Table[Interaction Type]= "inperson"))),
    [_1] =[_2]) ,[Account] )

     

    only msg=
    countx(filter(summarize(Table, Table[Account], "_1", count(Table[Interaction Type])
    , "_2",calculate(count(Table[Interaction Type]), filter(Table, Table[Interaction Type]= "msg"))),
    [_1] =[_2]) ,[Account] )

     

    Mutiple Interactions =
    countx(filter(summarize(Table, Table[Account], "_1", distinctcount(Table[Interaction Type])),
    [_1] >=2) ,[Account] )

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

Anonymous ,

only Call =
countx(filter(summarize(Table, Table[Account], "_1", count(Table[Interaction Type])
, "_2",calculate(count(Table[Interaction Type]), filter(Table, Table[Interaction Type]= "Call"))),
[_1] =[_2]) ,[Account] )

 

only inperson=
countx(filter(summarize(Table, Table[Account], "_1", count(Table[Interaction Type])
, "_2",calculate(count(Table[Interaction Type]), filter(Table, Table[Interaction Type]= "inperson"))),
[_1] =[_2]) ,[Account] )

 

only msg=
countx(filter(summarize(Table, Table[Account], "_1", count(Table[Interaction Type])
, "_2",calculate(count(Table[Interaction Type]), filter(Table, Table[Interaction Type]= "msg"))),
[_1] =[_2]) ,[Account] )

 

Mutiple Interactions =
countx(filter(summarize(Table, Table[Account], "_1", distinctcount(Table[Interaction Type])),
[_1] >=2) ,[Account] )

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Thank you Verymuch Amit . your promt response helped a lot 🙂