Power BI · मराठी आवृत्ती

13.10 ALL, ALLEXCEPT, REMOVEFILTERS, ALLSELECTED

रवींद्र बागले यांच्या course वर आधारित · सहज मराठीत explanation

Percentage-of-total साठी denominator मधून कोणते filters काढायचे हे ठरवावं लागतं.

All Category Sales = CALCULATE([Total Sales], ALL(Product))

% of All Categories = DIVIDE([Total Sales], [All Category Sales])

-- Share of a product within its category (keeps only the Category filter)
% of Category =
DIVIDE(
    [Total Sales],
    CALCULATE([Total Sales], ALLEXCEPT(Product, Product[Category]))
)

-- Share of a dark store within its city
% of City Orders =
DIVIDE(
    [Total Orders],
    CALCULATE([Total Orders], ALLEXCEPT(DarkStore, DarkStore[City]))
)

-- REMOVEFILTERS: same effect as ALL when used as a CALCULATE filter, clearer name
Orders All Cities = CALCULATE([Total Orders], REMOVEFILTERS(DarkStore))

-- Percentage of what the user has currently selected in slicers
% of Selected Total =
DIVIDE([Total Sales], CALCULATE([Total Sales], ALLSELECTED(Product)))

Category share, cityमधला store share आणि slicer-selected total चा share हे वेगळे denominators आहेत. ALLEXCEPT ठेवायचा filter प्रत्यक्ष context मध्ये आहे का तपासा; absent Category filter तो नव्याने बनवत नाही. ALLSELECTED complex iterators मध्ये नीट test करा.