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

PwerQueryKees's avatar
PwerQueryKees
Super User
1 year ago

Have you tried removing the =TRUE() altogether?

Leighla00's avatar
Leighla00
Frequent Visitor
1 year ago

Someone at my organization helped me.

 

CALCULATE (COUNTROWS (tablename), FILTER (tablename, tablename[Status] = in progress)).

 

Thanks for trying.