The true/false expression does not specify a column

[sg919]

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 database server.  I did read through the other similar posts, however not knowledgeable enough to attempt to modify the query.  Appreciate your assistance.

Sum Avg Calls/AE/Week per DSM_Name = 
CALCULATE (
    KEEPFILTERS ( VALUES ( 'Current Territory Alignments'[DSM_Name] ) ),
    DIVIDE (
        DIVIDE (
            DISTINCTCOUNT ( 'Call Activity'[Call_ID] ),
            DISTINCTCOUNT ( 'Call Activity'[Call_Dt (bins)] )
        ),
        DISTINCTCOUNT ( 'Call Activity'[Employee_ID] )
    )
)

[rocky09]

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

[sg919]

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

[ribisht17]

Without seeing data it is difficult to say ,DAX error: A function 'XXXX' has been used in a True/False expression that is used as a table filter...

Regards,

Ritesh

[sg919]

Here's a sample of the data

DSM Name	Employee_ID	Call_ID	Call_Dt (bins)
Manager 1	1234567	271516497	4/17/2022
Manager 1	1234567	271439167	4/24/2022
Manager 1	1234567	272173095	5/1/2022
Manager 1	1234567	272173059	5/1/2022
Manager 1	1234567	272173143	5/1/2022
Manager 1	758697	270574444	4/17/2022
Manager 1	758697	270713227	4/17/2022
Manager 1	758697	270224544	4/17/2022
Manager 1	9736455	269856799	4/24/2022
Manager 1	9736455	271410006	4/24/2022
Manager 1	9736455	271150056	4/24/2022
Manager 1	9736455	271126789	4/24/2022
Manager 1	9736455	271039378	4/24/2022
Manager 1	9736455	271569282	5/1/2022
Manager 1	9736455	271572208	5/1/2022
Manager 1	9736455	269822244	5/1/2022
Manager 2	64647748	270442448	4/17/2022
Manager 2	64647748	270741544	4/17/2022
Manager 2	64647748	270344529	4/17/2022
Manager 2	64647748	270739838	4/17/2022
Manager 2	64647748	270739036	4/17/2022
Manager 2	64647748	271330713	4/24/2022
Manager 2	64647748	271806760	5/1/2022
Manager 2	64647748	271597529	5/1/2022
Manager 2	64647748	272092586	5/1/2022
Manager 2	645423	270172824	4/17/2022
Manager 2	645423	270237618	4/17/2022
Manager 2	645423	270902261	4/24/2022
Manager 2	645423	272077691	5/1/2022
Manager 2	645423	271947825	5/1/2022
Manager 2	645423	272101605	5/1/2022
Manager 2	645423	271549373	5/1/2022

[v-shex-msft · Accepted solution]

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