cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Anonymous
Not applicable

## Measure to show both values £ AND Percentage %

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``````
1 ACCEPTED SOLUTION
Community Support

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

3 REPLIES 3
Community Support

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

Super User

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 my answer helped solve your problem, give it a kudos by clicking on the Thumbs Up.

If I helped you, click on the Thumbs Up to give Kudos.

Proud to be a Super User!

Continued Contributor

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

https://dax.guide/format/

Announcements

#### Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

#### Power BI Monthly Update - August 2024

Check out the August 2024 Power BI update to learn about new features.

#### Fabric Community Update - August 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors