Forum Discussion

Ikalaus's avatar
Ikalaus
Frequent Visitor
1 year ago
Solved

Displaying data

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_Percenta...
Need Help
  • bhanu_gautam's avatar
    bhanu_gautam
    1 year ago

    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")
    )

bhanu_gautam's avatar
bhanu_gautam
Super User
1 year ago

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")
)