Hide Visual Metrics based on Config file

Hi Arul 

Thank you very much Ritaf1983 for your prompt reply. Let me share a few things here.

Here I assume that your sales sheet looks like this:

“Sales”

Based on the data you provide, I recommend that you create measures for both visual objects separately.

Measure V1 = 
CALCULATE(
    SUM('Sales'[Value]),
    FILTER(
        'Config',
        'Config'[Visual] = "V1"
        &&
        'Config'[Metric Name] = SELECTEDVALUE('Sales'[Name])
        &&
        'Config'[Flag] <> 0
        ))

Measure V2 = 
CALCULATE(
    SUM('Sales'[Value]),
    FILTER(
        'Config',
        'Config'[Visual] = "V2"
        &&
        'Config'[Metric Name] = SELECTEDVALUE('Sales'[Name])
        &&
        'Config'[Flag] <> 0
        ))

Here is the result.

Regards,

Nono Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.