SUM MTD if multiple months are selected in filter
Hello All My date table is fiscal calendar 445. I have created below DAX for MTD MTD = CALCULATE ( SUM ( 'Sales invoice line fact'[Invoice TON_] ), FILTER ( ALL ( 'Report date' ), 'Report date'[Report year] = VALUES ( 'Report date'[Report year] ) && 'Report date'[Report month] = VALUES ( 'Report date'[Report month] ) && 'Report date'[Report date] <= MAX ( 'Report date'[Report date] ) ) ) Currently when i am trying to select multiple months it does not provide any output in grid . I want to enahnce \ my DAX to give me sum of MTD if multple months are selected in filter
