Displaying data

[Ikalaus]

I need to display the whole number as currency and if it is percent with 5 in the matrix view 

Formatted_Revenue =
VAR KPI_Name = TRIM(SELECTEDVALUE(KPI_budget[KPI], "Unknown"))
VAR Is_Percentage =
KPI_Name IN {"Service Margin %", "Gross Margin %", "EBITDA %", "C/R %"}
VAR Raw_Value =
CALCULATE(
SUM(KPI_budget[Revenue_budget]),
ALLEXCEPT(KPI_budget, KPI_budget[KPI], KPI_budget[fin_kpi])
)
VAR Percent_Value = Raw_Value * 100
RETURN
IF(
Is_Percentage,
FORMAT(Percent_Value, "$#,##0.00") & "%", -- Format the percentage with $ symbol
FORMAT(Raw_Value, "$#,##0.00")
).

What is the issue with this code? everything is showing with $  

Test_Is_Percentage =

VAR KPI_Name = TRIM(SELECTEDVALUE(KPI_budget[KPI], "Unknown"))

VAR Is_Percentage =

    CONTAINSSTRING(KPI_Name, "Margin %") ||

    CONTAINSSTRING(KPI_Name, "EBITDA %") ||

    CONTAINSSTRING(KPI_Name, "C/R %")

RETURN

IF(Is_Percentage, "Yes", "No")     this work correctly 

any idea?

[Ikalaus]

Thanks!  i find another way to fix 

[Anonymous]

Hi @Ikalaus ,

Since your issue appears to be resolved, kindly mark the relevant response as the accepted solution. This helps other community members quickly find answers to similar problems.
Thank you for your support and collaboration!

Regards,
B Manikanteswara Reddy

[Anonymous]

Hi @Ikalaus,

Just checking in — if the solution provided by the Super User resolved your issue, please consider marking it as the accepted answer.

If you're still facing trouble, could you please share a small sample of your dataset (ensuring it doesn't contain any sensitive information) along with the expected result? That would help in guiding you further.

Regards,

B Manikanteswara Reddy

[bhanu_gautam · Accepted solution]

@Ikalaus , Try using

DAX
Formatted_Revenue =
VAR KPI_Name = TRIM(SELECTEDVALUE(KPI_budget[KPI], "Unknown"))
VAR Is_Percentage =
KPI_Name IN {"Service Margin %", "Gross Margin %", "EBITDA %", "C/R %"}
VAR Raw_Value =
CALCULATE(
SUM(KPI_budget[Revenue_budget]),
ALLEXCEPT(KPI_budget, KPI_budget[KPI], KPI_budget[fin_kpi])
)
VAR Percent_Value = Raw_Value * 100
RETURN
IF(
Is_Percentage,
FORMAT(Percent_Value, "0.00") & "%", -- Format the percentage without $ symbol
FORMAT(Raw_Value, "$#,##0.00")
)