Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
nareshr89
Helper II
Helper II

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
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.