Count Disctint in DAX boolean values

[Vanessa250919]

Hello All, 

I try to make a new DAX function in my dataset :

# Answered Queue + Rona =

CALCULATE (

COUNTA ( 'FACT Interaction Segment'[Call ID] ),

'FACT Interaction Segment'[Rona Answered] = TRUE ()

)

+ CALCULATE (

COUNTA ( 'FACT Interaction Segment'[Call ID] ),

'FACT Interaction Segment'[Queue Answered] = TRUE ()

)

But I need a Distinct count return for [Call ID], is it possible ? 

Thanks 

[Anonymous · Accepted solution]

Hi @Vanessa250919 ,

It's ok to count boolean values. Try this measure.

Measure = CALCULATE(DISTINCTCOUNT('Table'[id]),FILTER(ALL('Table'),'Table'[boolean]=TRUE()))

 

In your formula you have missed the ")" after "true())".

Best Regards,

Jay

[PaulDBrown]

@Vanessa250919 

One way is to convert the boolean value to an integer:

INT(TRUE()) returns a value of 1 If true or blank if false. So use this expression in measure (instead of TRUE()) and then you can simply sum the values.

[PC2790]

Hello,

Did you try using DISTINCTCOUNT instead of COUNTA?

[Vanessa250919]

Yes but it's not Ok with true or false values . 

[PC2790]

Is [CallID] of type Boolean?

Can you please share your sample data please?

[Vanessa250919]

Nope, I need number of disctinct call ID when Rona answered is TRUE or FALSE 

[PC2790]

Then it should work, as you are trying to apply Count operation on CallID which is a non- boolean column, it won't have any issue.

See a small example I have done:

Two measures I created:

Count with COUNTA = CALCULATE(COUNTA('Table'[CallID]), FILTER('Table','Table'[Roma Answered]= TRUE()))

Outcome- 5

Count with DistinctCount = CALCULATE(DISTINCTCOUNT('Table'[CallID]),FILTER('Table','Table'[Roma Answered] = TRUE()))

Outcome-4

You can further do the required customizations

[Vanessa250919]

Thanks for your help, I try to add my other values like in bellow but it doent"s work 

[Vanessa250919]

I think I can make to calculate with boolean values in powerBI, always one issue message .