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!Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.
Hopefully a simple solution.
I have two measures to calculate:
- Count of tickets over 30 days
-% tickets over 30 days
I'd like to create a third measure to display the measures in a table similar to the below;
Week 1 | Week 2 | |
Team A | 75% , 4 | % , count |
Team B | 50% , 20 | 100%, 4 |
I've attemped to use the below however it returns the % as a decimal.
Measure = COMBINEVALUES(" , ",% measure, count measure)
Hi @Anonymous ,
Try with this:
Measure = FORMAT([% over 30 days],"#%") & " , (" & [30 Days] & ")"
Regards,
Chnage measure values to text and use concatenate
Thank you for the response. I have been able to produce the below.
How do I keep the [% over 30 days] to show as a % such as 25% rather than 25.3968...
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.