Forum Discussion

Leighla00's avatar
Leighla00
Frequent Visitor
1 year ago
Solved

Cannot Create Percentage off of True/False Data

I'm trying to create a calculation that will output a percentage based off of true/false data.       Completion Rate = CALCULATE(COUNT('2024'[Status]),'2024'[In Arbitration?]=TRUE()...
Tutorial Requests
  • BA_Pete's avatar
    BA_Pete
    1 year ago

    Hi Leighla00 ,

     

    You're trying to use the function version of TRUE(), rather than a scalar value.

    Try changing to this:

    CALCULATE(
    COUNT('2024'[Status]),
    '2024'[In Arbitration?] = 1
)

     

    Boolean values True/False are just the integers 1/0 in the background.

     

    Pete

BA_Pete's avatar
BA_Pete
Super User
1 year ago

Hi Leighla00 ,

 

You're trying to use the function version of TRUE(), rather than a scalar value.

Try changing to this:

CALCULATE(
    COUNT('2024'[Status]),
    '2024'[In Arbitration?] = 1
)

 

Boolean values True/False are just the integers 1/0 in the background.

 

Pete