CALCULATE(
              DISTINCTCOUNT('Остатки_Магнит'[Сцепка]);
              FILTER(ALLSELECTED('Остатки_Календарь_Магнит');
                        'Остатки_Календарь_Магнит'[Дата] <= MAX('Остатки_Календарь_Магнит'[Дата] ));'Остатки_Магнит'[Продажи, шт]>0)

Источник =
    Json.Document(
        Web.Contents(
            "https://api-seller.ozon.ru/v1/analytics/data",
            [
                Headers = [
                    #"Client-Id" = #"Внесите свои данные"[ClientId],
                    #"Api-Key" = #"Внесите свои данные"[ApiKey],
                    #"Content-Type" = "application/json"
                ],
                Content = Json.FromValue(
                    [
                        date_from = Date.ToText(#"Внесите свои данные"[DateStart], "YYYY-MM-DD"),
                        date_to = Date.ToText(Date.From(DateTime.LocalNow()) - #duration(1, 0, 0, 0), "YYYY-MM-DD"),
                        metrics = {
                                    "hits_view_search"
                                    ,"hits_view_pdp"
                                    ,"hits_tocart_search"
                                    ,"hits_tocart_pdp"
                                    ,"hits_tocart"
                                    ,"session_view_search"
                                    ,"conv_tocart_search"
                                    ,"conv_tocart_pdp"
                                    ,"revenue","returns"
                                    ,"ordered_units"
                                    ,"adv_sum_all"
                                    ,"position_category"
                                    ,"postings"
                                },
                        dimension = {
                                    "sku"
                        },
                        filters =#table({""},
                                {
                                    {""}
                                }
                            ),
                            
                        sort = 
                            #table({"key","order"},
                                {
                                    {"order", "ASC"}
                                }
                            ),
                        limit = 1000    
                        //offset = pOffset
                        
                    ]
                )
            ]
        )
    )[result][data]