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

v-lionel-msft's avatar
v-lionel-msft
Icon for Community Support rankCommunity Support
5 years ago

Hi Anonymous ,

 

Please refer to my .pbix file.

 

Best regards,
Lionel Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.