Count based on the periodic levels

[nareshr89]

My table contain the Year, Halfyear, Quarter, Month as seperate columns. I want to obtain a count DAX wherein if selected value is any quarter then count should be 3, any halfyear then 6, any month then 1 and 12 for the year. Also, if im changing the selection where in if i selected H1 and i untick one of the month below it then it should be count of remaining months ex 5 if one of the month is unselected. Below is the sample of the filter i will be using. 

[tamerj1 · Accepted solution]

Hi @nareshr89 

you can use SWITCH over TRUE for ISINSCOPE 

tou need to start from the smallest to the largest period.