Forum Discussion

poojik's avatar
poojik
Frequent Visitor
8 years ago

Error: DAX comparison operations do not support comparing values of type true/false

I am trying to create a new calcuated field to count all the account names if "ValidationStatus" is TRUE. The formula I am using is :    Validated count = CALCULATE(DISTINCTCOUNT(accounts[name]),FI...
Need Help
Vvelarde's avatar
Vvelarde
Community Champion
8 years ago

poojik

 

Hi try with this

 

Validated Count =
CALCULATE (
    DISTINCTCOUNT ( Accounts[name] );
    FILTER ( Accounts; Accounts[validationstatus] = TRUE () )
)

Regards

 

Victor

poojik's avatar
poojik
Frequent Visitor
8 years ago

Vvelarde

This was the first thing I tried previously but it didn't work. 

 

 

  • Vvelarde's avatar
    Vvelarde
    Community Champion
    8 years ago

    poojik

     

    Double Check the Data Type

     

     

    With this this work:

     

     

    Regards

    Victor

    • poojik's avatar
      poojik
      Frequent Visitor
      8 years ago

      The data type in Power BI desktop is True/False and the solution 

      Validated Count =
CALCULATE (
    DISTINCTCOUNT ( Accounts[name] );
    FILTER ( Accounts; Accounts[validationstatus] = TRUE () )
)

      works for power BI desktop. But when I publish the report on Power BI pro online. The data values chages to 0 and -1 hence the solution doesn't work.

       

      I am not able to edit the expression in power BI pro to make it compatible. 

       

      • v-jiascu-msft's avatar
        v-jiascu-msft
        Microsoft Employee
        8 years ago

        Hi poojik,

         

        Can you share a sample of the data?

         

        Best Regards,

        Dale