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

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
Anonymous
Not applicable

grouping and segmenting to count the number of rows in power bi using dax

I have one table named survey that contains rating numbers. I want to group these numbers based on certain conditions. For this, I have created another table named SupportTable. Based on the min and max from this table I want to group the rating. For this, I tried the following code but didn't get the desired result. I want to get the result in measure( Numbers Per Group). What I am doing wrong here?

 

Total number of feedback = COUNTROWS(Survey) #counts no of rows in survey table

Numbers Per Group = CALCULATE([Total number of feedback],

                        FILTER(VALUES(Survey[Rating]),

                           COUNTROWS(

                               FILTER('SupportTable',

                                  Survey[Rating]>= 'SupportTable'[Min]

                                  && Survey[Rating]< 'SupportTable'[Max]))

                                    >0))

question.jpg

1 ACCEPTED SOLUTION
AlB
Community Champion
Community Champion

Hi @Anonymous 

Numbers Per Group =
VAR min_ = SELECTEDVALUE ( 'SupportTable'[Min] )
VAR max_ = SELECTEDVALUE ( 'SupportTable'[Max] )
RETURN
    COUNTROWS ( FILTER ( Survey, Survey[Rating] >= min_ && Survey[Rating] < max_ ) )

Please mark the question solved when done and consider giving a thumbs up if posts are helpful.

Contact me privately for support with any larger-scale BI needs, tutoring, etc.

Cheers 

 

SU18_powerbi_badge

 

View solution in original post

3 REPLIES 3
amitchandak
Super User
Super User

@Anonymous , You have to use your independent table in measures and also need to push row context.

refer to my video on a similar topic can help you

https://www.youtube.com/watch?v=CuczXPj0N-k

File at : https://community.powerbi.com/t5/Quick-Measures-Gallery/Dynamic-Segmentation-Bucketing-Binning/m-p/1387187#M626

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube
AlB
Community Champion
Community Champion

Hi @Anonymous 

Numbers Per Group =
VAR min_ = SELECTEDVALUE ( 'SupportTable'[Min] )
VAR max_ = SELECTEDVALUE ( 'SupportTable'[Max] )
RETURN
    COUNTROWS ( FILTER ( Survey, Survey[Rating] >= min_ && Survey[Rating] < max_ ) )

Please mark the question solved when done and consider giving a thumbs up if posts are helpful.

Contact me privately for support with any larger-scale BI needs, tutoring, etc.

Cheers 

 

SU18_powerbi_badge

 

amitchandak
Super User
Super User

@Anonymous , refer if my video on similar topic can help you

https://www.youtube.com/watch?v=CuczXPj0N-k

File at : https://community.powerbi.com/t5/Quick-Measures-Gallery/Dynamic-Segmentation-Bucketing-Binning/m-p/1387187#M626

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.