cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Milozebre
Helper V
Helper V

If a cell contains true then 1

Hello Dear Community, 

 

I have a question. 

I have a table like that : 

L1L2L3Result expected 
TrueTrueTrue1
TrueTrueFalse1
TrueFalse True1
TrueFalse False1
FalseFalse True1
FalseTrueTrue1
FalseFalse False0

 

If he is one true on column then 1

If only false then 0

 

Can you help me please ?

 

Thank you.

1 ACCEPTED SOLUTION
PhilipTreacy
Super User
Super User

Hi @Milozebre 

 

Download this sample PBIX file with these examples.

 

Are they text values or Boolean True/False?

Do you want to do this in Power Query or DAX?

try this in Power Query assuming the column is text

 

if [L1] = "False" and  [L2] = "False" and  [L3] = "False" then 0 else 1

 

 

In DAX create this calculated column assumgin the column is True/False (Boolean)

 

Column = IF ([L1] = FALSE() && [L2] = FALSE() && [L3] = FALSE(), 0, 1)

 

 

If the columns are text then use this DAX

Column = IF ( CONTAINSSTRING('Table_Text'[L1], "False") && CONTAINSSTRING('Table_Text'[L2], "False") && CONTAINSSTRING('Table_Text'[L3], "False"), 0, 1)

 

tfvals.png

 

Regards

Phil



Did I answer your question? Then please mark my post as the solution.
If I helped you, click on the Thumbs Up to give Kudos.


Blog :: YouTube Channel :: Connect on Linkedin


Proud to be a Super User!


View solution in original post

3 REPLIES 3
timg
Super User
Super User

Hi Milozebre,

This calculated column should work:

 

Result =
SWITCH (
    TRUE (),
    'Table'[L1] = TRUE ()
        || 'Table'[L2] = TRUE ()
        || 'Table'[L3] = TRUE (), 1,
    0
)

 

1.PNG

Best regards,

Tim





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




PhilipTreacy
Super User
Super User

Hi @Milozebre 

 

Download this sample PBIX file with these examples.

 

Are they text values or Boolean True/False?

Do you want to do this in Power Query or DAX?

try this in Power Query assuming the column is text

 

if [L1] = "False" and  [L2] = "False" and  [L3] = "False" then 0 else 1

 

 

In DAX create this calculated column assumgin the column is True/False (Boolean)

 

Column = IF ([L1] = FALSE() && [L2] = FALSE() && [L3] = FALSE(), 0, 1)

 

 

If the columns are text then use this DAX

Column = IF ( CONTAINSSTRING('Table_Text'[L1], "False") && CONTAINSSTRING('Table_Text'[L2], "False") && CONTAINSSTRING('Table_Text'[L3], "False"), 0, 1)

 

tfvals.png

 

Regards

Phil



Did I answer your question? Then please mark my post as the solution.
If I helped you, click on the Thumbs Up to give Kudos.


Blog :: YouTube Channel :: Connect on Linkedin


Proud to be a Super User!


View solution in original post

Hello @PhilipTreacy 

 

Thank you for the solution, its works 🙂

Helpful resources

Announcements
Power BI December 2021 Update_carousel 768x460.jpg

Check it Out!

Click here to read more about the December 2021 Updates!

User Group Leader Meeting January 768x460.png

Calling all User Group Leaders!

Don't miss the User Group Leader meetings on January, 24th & 25th, 2022.

Jan 2022 Dev Camp 768x460 copy.png

Power BI Dev Camp- January 27th, 2022

Mark your calendars and join us for our next Power BI Dev Camp!

Top Solution Authors
Top Kudoed Authors