The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
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...
User | Count |
---|---|
24 | |
10 | |
8 | |
6 | |
5 |
User | Count |
---|---|
31 | |
12 | |
10 | |
10 | |
9 |