Forum Discussion
Calculated Column & Filter Context Issue between two related tables
Hi， Specialist707
Your [Coverage?] is a calculated column, so the column's value is static and won't be affected by the slicer "Year". In addition, Slicer 'Year' may filter out part of the data in 'Unique Table'.
You can try my steps below.
1.add a seperate legend table that has no relationship with other tables
2.add measure formula like:
Coverage? = IF ( MAX ( 'Unique Table'[Subcategory] ) IN VALUES ( 'Car History'[Subcategory] ), "Coverage", "No Coverage" )Subcategory count = CALCULATE ( DISTINCTCOUNT ( 'Unique Table'[Subcategory] ), FILTER ( 'Unique Table', [Coverage?] = MAX ( Legend[Coverage?] ) ) )Best Regards,
Community Support Team _ Eason
Hi， Specialist707
Your [Coverage?] is a calculated column, so the column's value is static and won't be affected by the slicer "Year". In addition, Slicer 'Year' may filter out part of the data in 'Unique Table'.
You can try my steps below.
1.add a seperate legend table that has no relationship with other tables
2.add measure formula like:
Coverage? =
IF (
MAX ( 'Unique Table'[Subcategory] ) IN VALUES ( 'Car History'[Subcategory] ),
"Coverage",
"No Coverage"
)
Subcategory count =
CALCULATE (
DISTINCTCOUNT ( 'Unique Table'[Subcategory] ),
FILTER ( 'Unique Table', [Coverage?] = MAX ( Legend[Coverage?] ) )
)
Best Regards,
Community Support Team _ Eason
Thanks - that is helpful. Is it possible to be able to filter on the bar chart so that if I select the 2 Coverage, then it filters the table on the top left to only show the records with coverage? How would I go about doing that?