Issue with Calculating SAT Metric in Power BI - Incorrect Aggregated Results

I'm encountering an issue while calculating the SAT (Satisfaction) metric in Power BI. The SAT metric is calculated based on grades received, where grades equal to 9 or 10 are considered positive (Promoters), and grades ranging from 0 to 6 are considered negative (Detractors). The formula I'm using to calculate SAT is as follows:

    SAT =
VAR TotalRows = COUNTROWS(ALLSELECTED(SAT_SHEET))
VAR PromoterRows =
    CALCULATE(
        COUNTROWS(SAT_SHEET),
        SAT_SHEET[GRADE] >= 9 && SAT_SHEET[GRADE] <= 10,
        ALLSELECTED(SAT_SHEET)
    )
VAR DetractorRows =
    CALCULATE(
        COUNTROWS(SAT_SHEET),
        SAT_SHEET[GRADE] >= 0 && SAT_SHEET[GRADE] <= 6,
        ALLSELECTED(SAT_SHEET)
    )
RETURN
    100 * (PromoterRows - DetractorRows) / TotalRows

However, when I try to create a table, matrix, or line chart to display the SAT results aggregated by location, code, or month, the calculation does not yield the correct values. Strangely, when I manually apply filters in Power BI, the SAT calculation produces the expected results. How can I fix my formula to obtain the desired outcome?

I have a dataset containing the following columns:

To ilustrate my issue let me show you:

When I apply my SAT to a line chart I get this:

whic is incorrect but If I filter (In a dat filter) my data by month (Mayo) it does give me the proper correct value:

and the same goes for location and code I cant seem to find a way to properly show the resulting SAT by location, code and date in a table viz or in a line viz. How can I fix this issue and correctly display the SAT measure over the months, locations and codes of the dataset?

Using ALLSELECTED() removes the filter coming from the row context. EG if you write a simple row counting measure like

Rows = countrows(allselected(SAT_SHEET))

You get

So try something like:

    SAT = 
    VAR TotalRows = COUNTROWS(SAT_SHEET)
    VAR PromoterRows =
        CALCULATE(
            COUNTROWS(SAT_SHEET),
            SAT_SHEET[GRADE] >= 9 && SAT_SHEET[GRADE] <= 10
        )
    VAR DetractorRows =
        CALCULATE(
            COUNTROWS(SAT_SHEET),
            SAT_SHEET[GRADE] >= 0 && SAT_SHEET[GRADE] <= 6
        )
    RETURN
        100 * (PromoterRows - DetractorRows) / TotalRows