Suppose
dates Sales
2018 / 10 / 29 20
2018 / 11 / 30 20
2018 / 11 / 30 30
2018 / 11 / 30 40
2018 / 11 / 30 50
2018 / 12 / 30 60
2018 / 12/ 30 30
2018 / 12 / 30 20
2018 / 12 / 30 40
2018 / 12 / 31 60
2018 / 12/ 31 30
2018 / 12 / 31 20
2018 / 12 / 31 40
with the help of below measure we can easily get mtd but i need a number of row its get for calculating mtd like given below
MTD_SALE = CALCULATE(SUM('Table'[Sales]),DATESMTD('Table'[Date]))
need a solution like FTD 150 MTD 300
4 8
Replace SUM() with COUNTROWS()