I'm working on a Scorecard application. There are two tables: Metrics and CRMTransactions. They are linked by MetricId.
I have a straight table with Metric ID as a dimension. For one of my calculations I need to count transactions for a metric and divide them by the count of a different metric. It seems like this should be an easy calculation with set analysis but I can't seem to get it right. Here's my expression: