KPI Formatting

[Anonymous]

I have a page of KPIs for sales by each channel. I have created a dynamic switcher that allows me to switch between total $ amount and percentage of total. However, whenever I try to format these measure it returns blank.

For example:

Switcher = SWITCH([Selected Measure],1,FORMAT([Direct Mail $],"$000,000.00"),2,CALCULATE(SUM([Total Sales]), [channel] = "Direct Mail"))/FORMAT(SUM('[Total Sales]),"0.00%")

[v-jiascu-msft · Accepted solution]

Hi @Anonymous,

I tried it like below successfully. You can give it a try.

Switcher =
SWITCH (
    [Selected Measure],
    1, FORMAT ( [Direct Mail $], "$000,000.00" ),
    2, FORMAT (
        CALCULATE ( SUM ( [Total Sales] ), [channel] = "Direct Mail" )
            / SUM ( [Total Sales] ),
        "0.00%"
    )
)

Best Regards,

Dale

[RMDNA]

Hi @Anonymous,

I would set your calculations inside the measure using VAR and then just call them in SWITCH.

[Anonymous]

That still does not work. It seems that using the FORMAT() function is not allowed in a KPI