Forum Discussion
Create a calculation using filter after some condition
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 ?
5 Replies
- amitchandakSuper User
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
- UditJHelper III
In the same calculation can we include data range? For Example - 28th Feb - 5th March means the calculation works for only this date range.
- Sahir_MaharajSuper User
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" ) ) )- UditJHelper III
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?
- UditJHelper III
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 ?