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

  • Tahreem24's avatar
    Tahreem24
    6 years ago

    Anonymous , Thanks for this catch.

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.