cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
nareshr89
Helper I
Helper I

Count based on the periodic levels

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. 

 

 

nareshr89_0-1652352430892.png

1 ACCEPTED SOLUTION
tamerj1
Super User
Super User

Hi @nareshr89 

you can use SWITCH over TRUE for ISINSCOPE 

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

View solution in original post

1 REPLY 1
tamerj1
Super User
Super User

Hi @nareshr89 

you can use SWITCH over TRUE for ISINSCOPE 

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

Helpful resources

Announcements
PBI Sept Update Carousel

Power BI September 2023 Update

Take a look at the September 2023 Power BI update to learn more.

Learn Live

Learn Live: Event Series

Join Microsoft Reactor and learn from developers.

Dashboard in a day with date

Exclusive opportunity for Women!

Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!

MPPC 2023 PBI Carousel

Power Platform Conference-Power BI and Fabric Sessions

Join us Oct 1 - 6 in Las Vegas for the Microsoft Power Platform Conference.

Top Solution Authors
Top Kudoed Authors