Forum Discussion

sg919's avatar
sg919
Frequent Visitor
4 years ago
Solved

The true/false expression does not specify a column

Hello - novice here.  Trying to fix an the "true/false" expression error from a query I inherited.  I am using Power BI Desktop, Version: 2.105.664.0 64-bit (May 2022).  This query connects to our da...
Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi sg919,

    You can try to use the following measure formula if it is suitable for your requirement:

    formula =
CALCULATE (
    DISTINCTCOUNT ( 'Call Activity'[Call_ID] )
        / DISTINCTCOUNT ( 'Call Activity'[Call_Dt (bins)] )
        / DISTINCTCOUNT ( 'Call Activity'[Employee_ID] ),
    ALLSELECTED ( 'Call Activity' ),
    VALUES ( 'Current Territory Alignments'[DSM_Name] )
)

    Regards,

    Xiaoxin Sheng

rocky09's avatar
rocky09
Solution Sage
4 years ago

I suspect the data type of the column might be auto-selected as True/False. Check once.

  • sg919's avatar
    sg919
    Frequent Visitor
    4 years ago

    Not sure how to check.  When I click on the column here's what I see.