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

Anonymous's avatar
Anonymous
Not applicable
1 year ago

Hi Leighla00 ,

 

Thank you for reaching out to the Microsoft fabric community forum. regarding the issue your a facing to create a percentage of True/False data.

 

As BA_Pete already mentioned, please try using the suggested solution. And also it appears that you have found a resolution. If so, kindly mark the helpful reply and accept it as the solution. This will assist other community members in resolving similar issues more efficiently. Feel free to contact us if you have any further questions.

 

Thank you.