Power BI Help With Creating a Filter

HI AB_34 

Use this DAX formula to create a column that flags whether a site qualifies as a FreeWire Site:

Is FreeWire Site = 
IF(
    CALCULATE(
        MAX('Table'[Configured Output (kWh)]), 
        ALLEXCEPT('Table', 'Table'[Site Name])
    ) >= 200,
    "Yes",
    "No"
)

Drag the Is FreeWire Site column into the slicer.
Select "Yes" in the slicer to filter your visuals to display only FreeWire Sites

Hi AB_34 

Thanks for the reply from lbendlin and Bibiano_Geraldo , please allow me to provide another insight:

You can also try the following Measure

IsFreeWireSite = 
VAR _SiteName = CALCULATE(MAX([Site Name]), FILTER(ALLEXCEPT('Table', 'Table'[Site Name]), [Configured Output (kWh)] = 200))
RETURN
IF(MAX([Site Name]) = _SiteName, 1, 0)

Output:

Best Regards,
Yulia Xu

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