Forum Discussion

Mahmoodul's avatar
Mahmoodul
Helper I
6 years ago
Solved

Please Convert this Tableau LOD function into Power Bi DAX

{ FIXED [Report Date],[Iw Oow Flag],[Client_Type],[Open Closed] : COUNTD([Sb Contractcall])}

Need Help
  • Tahreem24's avatar
    Tahreem24
    6 years ago

    You can give a try to below Dax:

     

    =Calculate(DistinctCount(Table[Sb Contractcall]), AllExcept(Table, Table[Report Date],Table[Iw Oow Flag],Table[Client_Type],Table[Open Closed))

     

     

  • Anonymous's avatar
    Anonymous
    6 years ago

    Hi Mahmoodul ,

     

    I think you might use DISTINCTCOUNT() instead of COUNT() in the formula above.

     

    Best Regards,

    Jay

3 Replies

  • Tahreem24's avatar
    Tahreem24
    Super User
    6 years ago

    You can give a try to below Dax:

     

    =Calculate(DistinctCount(Table[Sb Contractcall]), AllExcept(Table, Table[Report Date],Table[Iw Oow Flag],Table[Client_Type],Table[Open Closed))

     

     

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Hi Mahmoodul ,

     

    I think you might use DISTINCTCOUNT() instead of COUNT() in the formula above.

     

    Best Regards,

    Jay

    • Tahreem24's avatar
      Tahreem24
      Super User
      6 years ago

      Anonymous , Thanks for this catch.