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

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more

Reply
TFTF_BI
Helper I
Helper I

Create a measure that splits another measure into categories

Hi, 

I am working on creating a visual to show what students have improved, not improved or not significantly changed between 2 time frames. 

 

So currently have been able to build measures to show the below:

Measure 1 - gives me the average increase / decrease over 20 students. 

TF1 = 70% average over 20 students 

TF2 = 90% average over the same 20 students

Showing an increase of 28.5% [Difference_Attendance_Percentage]

 

Measure 2 - gives me a count of how many students within the 28.5% improved 

Count_Students_Attendance_Improved =
COUNTX(
FILTER(VALUES(Students[school_student_id]),
'Measures'[Difference_Attendance_Percentage]>0),
Students[school_student_id])
 
Is it possible to recreate the 3rd measure to split the [Difference_Attendance_Percentage] measure into 3 catorgories to use within a visual? 
 
Each category will be a count of the ammount of students that fit the criteria. 
 
Cat 1: Improved - student percentage is >0.05 
Cat 2: Did Not Improve - student percentage is <-0.05
Cat 3: Did Not Change - student percentage is >-0.05 & <0.05

The idea is that I can drop this into a pie chart and the chart will show me 3 sections by the value of count in each. 
 
Maybe I am think about this the wrong way? 
 
Would appreciate any help on this. 

 

1 ACCEPTED SOLUTION
amitchandak
Super User
Super User

@TFTF_BI , if you have three measures, you can put them in pie without legend , that will work.

 

Or you can create a calculation group

Calculation Groups- Measure Slicer, Measure Header Grouping, Measure to dimension conversion. Complex Table display : https://youtu.be/qMNv67P8Go0

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

View solution in original post

2 REPLIES 2
TFTF_BI
Helper I
Helper I

Thanks @amitchandak Didnt realise it was going to be as simple as that!  Didnt realise you could just make the 3 measures then drop them in the values section. 

amitchandak
Super User
Super User

@TFTF_BI , if you have three measures, you can put them in pie without legend , that will work.

 

Or you can create a calculation group

Calculation Groups- Measure Slicer, Measure Header Grouping, Measure to dimension conversion. Complex Table display : https://youtu.be/qMNv67P8Go0

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
November Power BI Update Carousel

Power BI Monthly Update - November 2025

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

Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Top Solution Authors
Top Kudoed Authors