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

  • sg919's avatar
    sg919
    Frequent Visitor
    4 years ago

    Here's a sample of the data

    DSM NameEmployee_IDCall_IDCall_Dt (bins)
    Manager 112345672715164974/17/2022
    Manager 112345672714391674/24/2022
    Manager 112345672721730955/1/2022
    Manager 112345672721730595/1/2022
    Manager 112345672721731435/1/2022
    Manager 17586972705744444/17/2022
    Manager 17586972707132274/17/2022
    Manager 17586972702245444/17/2022
    Manager 197364552698567994/24/2022
    Manager 197364552714100064/24/2022
    Manager 197364552711500564/24/2022
    Manager 197364552711267894/24/2022
    Manager 197364552710393784/24/2022
    Manager 197364552715692825/1/2022
    Manager 197364552715722085/1/2022
    Manager 197364552698222445/1/2022
    Manager 2646477482704424484/17/2022
    Manager 2646477482707415444/17/2022
    Manager 2646477482703445294/17/2022
    Manager 2646477482707398384/17/2022
    Manager 2646477482707390364/17/2022
    Manager 2646477482713307134/24/2022
    Manager 2646477482718067605/1/2022
    Manager 2646477482715975295/1/2022
    Manager 2646477482720925865/1/2022
    Manager 26454232701728244/17/2022
    Manager 26454232702376184/17/2022
    Manager 26454232709022614/24/2022
    Manager 26454232720776915/1/2022
    Manager 26454232719478255/1/2022
    Manager 26454232721016055/1/2022
    Manager 26454232715493735/1/2022
    • Anonymous's avatar
      Anonymous
      Not applicable
      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