Preserving Filters with KEEPFILTERS

intermediate

+120 XP

1 day

Concept:KEEPFILTERS

Objective

Create a measure 'Kept Enterprise Sales' that uses KEEPFILTERS around Customers[Segment] = 'Enterprise' so existing slicers are intersected rather than replaced.

Required Functions:

CALCULATE()KEEPFILTERS()

Power BI Visual Simulation

Filter Context:

📅 Year = 2025🌍 Country = All🏷️ Segment = All

Preserving Filters with KEEPFILTERS

— — —

Awaiting valid DAX formula check

Guided Hints

0 of 1 revealed

[fx]Kept Enterprise Sales=

Loading DAX Formula Studio...

Ctrl+Enter Check•Ctrl+Shift+F Format•Type [ for fields

Model

[fx]Total Revenue

[fx]Total Cost

[fx]Total Profit

[fx]Profit Margin %

[fx]Total Quantity

[fx]Total Orders

[fx]Customer Count

[fx]Average Order Value

[fx]Previous Year Revenue

[fx]YoY Revenue Growth %

🔑SaleID

📅Date

🔑CustomerID

🔑ProductID

∑Quantity

∑Revenue

∑Cost

🔑CustomerID

AaCustomerName

AaCountry

AaSegment

Click field to copy syntaxDAX Active