Forum Discussion
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 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] )
)
)
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
5 Replies
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 expression. This is not allowed. - SQLGene Training
Regards,
Ritesh
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 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
I suspect the data type of the column might be auto-selected as True/False. Check once.
Not sure how to check. When I click on the column here's what I see.
