Forum Discussion

5 Replies

  • 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's avatar
      UditJ
      Helper 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. 

  • 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's avatar
      UditJ
      Helper 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? 

  • 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 ?