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

Anonymous's avatar
Anonymous
Not applicable
1 year ago

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