min / max on boolean

[Bebs]

Hello !

Is there a way to use min or max functions equivalent on boolean fields ?

I've a boolean field, I'd like to write a DAX calculation (as efficient as possible) to know if it does exists TRUE values or FALSE values in a boolean field.

Can you please help me ?

Thanks !

[Anonymous]

Hi, @Bebs 

Thanks @Tahreem24 . I have the following additions, and based on your description, I have created the following sample data:

In aggregate functions, only the following functions can aggregate Boolean columns:

You can eradicate what these aggregaters return and adjust them to suit your scenario. I've uploaded the PBIX file I used this time below.

How to Get Your Question Answered Quickly

If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .

Best Regards

Jianpeng Li

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Bebs]

My point can be reformulate to use an AND or an OR functions on every values of a field (and not only two values) As if AND and OR Functions were aggregate functions.

[Tahreem24]

@Bebs Can you share some input data example and your expected output?