Measure to show both values £ AND Percentage %

[Anonymous]

Hi Experts

Can i change the following measure to show a Value and Percentage i.e 257 (3%)

Profitability_Summary_Channel =
VAR Mth1 =
SELECTEDVALUE ( SelMth[Month] )
VAR yr =
SELECTEDVALUE ( Year_Grp[Year] )
VAR Fcst1 =
SELECTEDVALUE ( SelMth4[Actual] )
VAR Acct =
SELECTEDVALUE ( Grp_Sumry_Rep[AccountGroup] )


VAR MthVal =

CALCULATE (
SUM ( Profitability_Consolidation[Profit]),
Profitability_Consolidation[Period] = Fcst1,Profitability_Consolidation[Year] = yr, Profitability_Consolidation[AccountGroup] = Acct,  Profitability_Consolidation[Product] = "Total"
)
RETURN
MthVal

[V-pazhen-msft · Accepted solution]

@Anonymous 
For example, if you have measure = 1, you can create following dax to get currency and percent.

Measure 2 = CONCATENATE(FORMAT([Measure],"Currency"),CONCATENATE(" / ",FORMAT([Measure],"Percent")))

Paul Zheng _ Community Support Team
If this post helps, please Accept it as the solution to help the other members find it more quickly.

[PhilipTreacy]

Hi @Anonymous 

Alternatively, create your measure and then create another measure equal to it i.e.

Measure 2 = Measure 1

You can then set the formats of each measure independently in the Data tab -> Measure Tools and retain the data type rather than converting to string with FORMAT.

Regards

Phil

---

If I answered your question please mark my post as the solution.
If my answer helped solve your problem, give it a kudos by clicking on the Thumbs Up.

[Johanno]

You can use the FORMAT function to define format within a measure, e.g. RETURN Value1 & " " & FORMAT(Value2, "Percent")

https://dax.guide/format/