Forum Discussion
INTERSECT between 2 Tables with different Filter Values
Hi Everyone, I would appreciate any assistance you could provide. I have two tables that share a Many to Many relationship. The first is a record of all activities created by our staff and the secon...
As there exist a many to many relationship across the two tables, create a calcuated column in the Policy table.
Count Of Policies= COUNTX (
SELECTCOLUMNS (
FILTER ( RELATEDTABLE ( 'Activities' ), 'Activities'[Activity Type] = "TF" ),
"Cnt", 'Policy'[Policy Number]
),
'Policy'[Policy Number]
)
Thank you for your assistance. I am receiving the following error when I try to implement this formula:
"A single value for column 'PolicyNumber' in table 'Policy' cannot be determined. Thias can happen when a measure formula refers to a column that contains many values without specifying an aggregation such as min, max, count, or sum to get a single result."
You have to create a calculated column.