Forum Discussion
Solved
DAX calculation based on 2 text values in same column
Hi guys, I feel like this one might be an easy one, but for some reason I can't get it. Working Dax 1: Abandoned = SUM('Inbound Queues'[Abandon]) Working Dax 2 Total Abandoned = CAL...
in theory this should work but haven't tested it
Total Abandoned =
CALCULATE (
[Abandoned],
FILTER (
ALL ( 'Inbound Queues'[queue_name] ),
'Inbound Queues'[queue_name] IN { "FS - FC Queue", "MQ - FC Queue" }
)
)
in theory this should work but haven't tested it
Total Abandoned =
CALCULATE (
[Abandoned],
FILTER (
ALL ( 'Inbound Queues'[queue_name] ),
'Inbound Queues'[queue_name] IN { "FS - FC Queue", "MQ - FC Queue" }
)
)
Thanks so much vanessafvg! This works perfectly 😁