"AND" statement DAX

Question

Hi ,&nbsp;Im trying to have a column containing either 1 or 0 depending on following condition in DAX:&nbsp;"OpenIncident", IF ( AND(&nbsp; &nbsp; &nbsp; &nbsp; CALCULATE (&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; COUNTROWS ( 'tableA' ),&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ALLEXCEPT (&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 'tableA',&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 'tableA'[SubGroup],&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 'tableA'[incidentNumber]&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ),&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 'tableA'[Change Status] in {"Logged", "Waiting", "Updated"})&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;,&nbsp;&nbsp; &nbsp; &nbsp; &nbsp; CALCULATE (&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; COUNTROWS ( 'tableA' ),&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ALLEXCEPT (&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 'tableA',&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 'tableA'[SubGroup],&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 'tableA'[incidentNumber]&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ),&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 'tableA'[Status Name] in {"Logged", "Updated","In progress"})&nbsp;&nbsp; &nbsp; &nbsp; &nbsp; ) &gt; 0,&nbsp; &nbsp; &nbsp; &nbsp; 1,&nbsp; &nbsp; &nbsp; &nbsp; 0&nbsp; &nbsp; &nbsp; &nbsp; ))&nbsp;So if both statements are true, it should give me a "1" in the column, otherwise "0"&nbsp;&nbsp;I keep getting following error but cant seem to make it work:DAX comparison operations do not support comparing values of type True/False with values of type Integer. Consider using the VALUE or FORMAT function to convert one of the values.

shubham_tekade · Accepted Answer

Hello,&nbsp;"OpenIncident", IF ( AND(&nbsp; &nbsp; &nbsp; &nbsp; CALCULATE (&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; COUNTROWS ( 'tableA' ),&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ALLEXCEPT (&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 'tableA',&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 'tableA'[SubGroup],&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 'tableA'[incidentNumber]&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ),&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 'tableA'[Change Status] in {"Logged", "Waiting", "Updated"})&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;,&nbsp;&nbsp; &nbsp; &nbsp; &nbsp; CALCULATE (&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; COUNTROWS ( 'tableA' ),&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ALLEXCEPT (&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 'tableA',&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 'tableA'[SubGroup],&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 'tableA'[incidentNumber]&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ),&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 'tableA'[Status Name] in {"Logged", "Updated","In progress"})&nbsp;&nbsp; &nbsp; &nbsp; &nbsp; ) ,-- This will giving you true/ flase in output and here you are trying to compare with like (True/false)&gt;0. this will not work.&nbsp; &nbsp; &nbsp; &nbsp; 1,&nbsp; &nbsp; &nbsp; &nbsp; 0&nbsp; &nbsp; &nbsp; &nbsp; )&nbsp;try this it will work for you I think so.&nbsp;thanks.&nbsp;&nbsp;&nbsp;

Forum Discussion

"AND" statement DAX

2 Replies

Related content

DAX formula to combine "Filter" and "ALL"

Options and recommendations to use "Private Link" with both "Fabric SQL database" and "Purview?"

"and" statement in M Language

"Parent Slicer" and resetting "Child Slicers" using parameter tables?

icon name for "Red Up Arrow" and "Green Down Arrow" in the DAX code