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

Ikalaus's avatar
Ikalaus
Frequent Visitor
1 year ago

Thanks!  i find another way to fix 

Anonymous's avatar
Anonymous
Not applicable
1 year ago

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