Combine two non-text measures

[Anonymous]

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)

[Payeras_BI]

Hi @Anonymous ,

Try with this:

Measure = FORMAT([% over 30 days],"#%") & " , (" & [30 Days] & ")"

Regards,

[srlabhe123]

Chnage measure values to text and use concatenate

[Anonymous]

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...

Measure = ([% over 30 days]*100) & " , (" & [30 Days] & ")"