Create a calculation using filter after some condition

[UditJ]

I need to create a calculation where after meeting the condition it should filter out measure values. 

Condition is - If City = Australia && Town = A || Town = B || Town = C then Filter out Measure Values ( Sales , Profit Etc.) 

Any suggestions ? 

[UditJ]

Thanks for sharing your input, I will try this out. Also, can we include a time range in the calculation (which is to be filtered out) . Any suggestions on this ?

[Sahir_Maharaj]

Hello @UditJ,

Can you please try to structure your DAX formula as follows:

FilteredMeasure =
CALCULATE(
    [YourMeasure],  // Your actual measure, e.g., [Sales]
    FILTER(
        'YourTable',  // Your actual table name
        'YourTable'[City] = "Australia" &&
        (
            'YourTable'[Town] = "A" ||
            'YourTable'[Town] = "B" ||
            'YourTable'[Town] = "C"
        )
    )
)

[UditJ]

Thanks for your input, I will try this out, also can we include a specific time range (Which is to be filtered) in the same calculation? 

[amitchandak]

@UditJ , You can create new mesures like

Calculate([Sales], filter(Table, Table[City] ="Australia" && Table[Town] in {"A", "B", "C"}) )

Calculate([Profit], filter(Table, Table[City] ="Australia" && Table[Town] in {"A", "B", "C"}) )

Or create a calculation group hand have item like

Calculate(selectedmeasure()  filter(Table, Table[City] ="Australia" && Table[Town] in {"A", "B", "C"}) )

Model explorer public preview with calculation group authoring| Measure Slicer: https://youtu.be/VfxfJJ0RzvU

[UditJ]

In the same calculation can we include data range?  For Example - 28th Feb - 5th March means the calculation works for only this date range.