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
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

poojik's avatar
poojik
Frequent Visitor
8 years ago

Hi v-jiascu-msft 

 

The test data is attached. The data is downloaded from Dynamics CRM accounts entity. There are 6 fields with data in 14 rows :

1. Name : Text field

2. Validation status : Option set

3. Created on : Date and Time field

4. Rsubmitted : Option set

5. Units : Whole Number

6. Region : Text field 

'

Now because I have to find out the absolute percentage of names that has Rsubmitted as "Yes"  (example out of 4 Toronto records 3 has Rsubmitted as "Yes". Hence the percentage is 75%)

 

To find out hte percentage i have created a calcuated field : 

 

Validated count =CALCULATE(DISTINCTCOUNT(accounts[name]),accounts[Rsubmitted]= "TRUE")

 

Absolute_percentage = (([Validated count])/(count(accounts[Name])))

 

The calculations are valid and am able to plot stacked bar graph (Screen-shot attached)

 

But when I try to publish this graph to Power BI pro- the data type for Rsubmitted" changes from TURE/FLASE to 1/0 (Screen-shot attached)