Forum Discussion
UditJ
Helper III
Helper IIICreate 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 Measur...
amitchandak
Super User
Super UserUditJ , 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
Helper IIIIn the same calculation can we include data range? For Example - 28th Feb - 5th March means the calculation works for only this date range.