Count Month for selected year in slicer

[Chandrashekar]

Hello,

Kindly help to calculate month count as below. I have two slicers one for Year and one for month but it should not effect measure.

Date	Year	Month Count
1/1/2022	2022	2
1/2/2022	2021	11
1/1/2021	2020	3
1/2/2021
1/3/2021
1/5/2021
1/6/2021
1/7/2021
1/8/2021
1/9/2021
1/10/2021
1/11/2021
1/12/2021
1/1/2020
2/1/2020
7/1/2020

[Samarth_18]

Hi @Chandrashekar ,

Create a measure like below:-

Measure =
CALCULATE (
    COUNT ( 'Table'[Date] ),
    FILTER (
        'Table',
        YEAR ( 'Table'[Date] ) = SELECTEDVALUE ( Date[Year] )
            && MONTH ( 'Table'[Date] ) = SELECTEDVALUE ( Date[Month No] )
    )
)

Thanks,

Samarth

[Chandrashekar]

Hello Samarth,

am getting wrong count. am attaching sample report. Sample Report 

Measure should not consider slicer(Month No) only it should consider slicer(year).

I want count of months for selected year.

[Samarth_18]

@Chandrashekar  disable filtering of table with edit interaction and use formula like below:-

MonthCount = 
        CALCULATE(
                Count('Date'[Date]),
                FILTER(
                        'Date',
                        year('Date'[Date])=SELECTEDVALUE('Date'[Year]) 
                ))

Update file url below:-

https://we.tl/t-0YmyYsvYCs 

[Chandrashekar]

Hello Samarth,

If i change month count is getting effected. even we change month values should not get effected.

[Samarth_18]

use edit interaction to disable filter on card.

[Chandrashekar]

Hello Samarth,

Thanks,

Regards,

Chandrashekar B

[amitchandak · Accepted solution]

@Chandrashekar ,

Create a month Year column

month Year = date([Year])*100 + month([Date])

countx(values(Table[month Year]), [month Year] )

[Chandrashekar]

Hello Amit,

Sorry for wrong question. I need count in Card as below. When user selected 2020 I should output as 3.