Forum Discussion

Specialist707's avatar
Specialist707
Frequent Visitor
3 years ago
Solved

Calculated Column & Filter Context Issue between two related tables

Hi Everyone,   I'm trying to create a dashboard to show if there has been coverage, or no coverage for a specific car. This includes comparing the two tables to see if both subcategories exist. If ...
Need Help
  • v-easonf-msft's avatar
    v-easonf-msft
    3 years ago

    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