Please Convert this Tableau LOD function into Power Bi DAX

[Mahmoodul]

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

[Tahreem24 · Accepted solution]

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

[v-jayw-msft · Accepted solution]

Hi @Mahmoodul ,

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

Best Regards,

Jay

[v-jayw-msft · Accepted solution]

Hi @Mahmoodul ,

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

Best Regards,

Jay

[Tahreem24 · Accepted solution]

@v-jayw-msft , Thanks for this catch.

[Tahreem24 · Accepted solution]

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