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!To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount now.
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...