Forum Discussion
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...
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
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