Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes! Register now.
I work in a school district that uses Power BI. I need to create a visualization that breaks down enrollment by building, by grade with a subtotal for the current year. But then I need a row with the subtotal of the enrollment count from last year and a column that shows th difference. When I build it in a matrix, and add my measure for last year enrollment count it shows last year enrollment count by grade level. I need it to look more like the first image here which is a Google sheet. The second image is what it looks like in desktop. Is there a way to stop the matrix from breaking down the last year value by grade?
Solved! Go to Solution.
@CoordAnalytics
You can wrap your calculation within
IF ( NOT ( ISFILTERED ( TABLE[GRADE]) , [YOUR MEASURE CODE] )
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
@CoordAnalytics
You can wrap your calculation within
IF ( NOT ( ISFILTERED ( TABLE[GRADE]) , [YOUR MEASURE CODE] )
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!
Check out the September 2025 Power BI update to learn about new features.