Forum Discussion

JimJim's avatar
JimJim
Responsive Resident
8 years ago
Solved

Dax Countx

Hi Guys, I am struggling with a simple countx statement in dax. The following dax isn't working for me, I am getting error 'The function COUNTX cannot work with values of type boolean'   CompletedQ...
Need Help
  • Greg_Deckler's avatar
    Greg_Deckler
    8 years ago

    Try this:

     

    CompletedQuery = COUNTX(FILTER('TraceData',TraceData[EventClass] = "RPC:Completed" || TraceData[EventClass] = "SQL:BatchCompleted"), TraceData[EventClass])
Greg_Deckler's avatar
Greg_Deckler
Community Champion
8 years ago

Try this:

 

CompletedQuery = COUNTX(FILTER('TraceData',TraceData[EventClass] = "RPC:Completed" || TraceData[EventClass] = "SQL:BatchCompleted"), TraceData[EventClass])
ppraca's avatar
ppraca
Frequent Visitor
4 years ago

Hi, is there a soution to take the unique values from your expression: 

FILTER('TraceData',TraceData[EventClass] = "RPC:Completed" || TraceData[EventClass] = "SQL:BatchCompleted")

The filter returns a table and I want to count the unique values.

Thanks,

Paulo Praça