How to show 0.00% if it is blank that due to zero

[Anonymous]

I am trying to create a measured table that show percentage, and if it is non available it show -, but some of the value become blank due to value 0, but i would like to show it as 0.00% as well. Anyone know how to solve this?

SummaryTable =

SUMMARIZE (

    Table,

    Table[ID],

    "Price", IF(CALCULATE(COUNTA(Table[product]))>0,FORMAT(DIVIDE(CALCULATE(COUNTA(Table[product]),Table[product]="lemon"),CALCULATE(COUNTA(Table[product]))),"0.00%"),"-")

[Jihwan_Kim · Accepted solution]

Hi,

Could you please try something like below whether it suits your requirement?

Summary Table =
SUMMARIZE (
    Table,
    Table[ID],
    "Price",
        SWITCH (
            TRUE (),
            CALCULATE ( COUNTA ( Table[product] ) ) > 0,
                FORMAT (
                    DIVIDE (
                        CALCULATE ( COUNTA ( Table[product] ), Table[product] = "lemon" ),
                        CALCULATE ( COUNTA ( Table[product] ) )
                    ),
                    "0.00%"
                ),
            CALCULATE ( COUNTA ( Table[product] ) )
                == 0
                    || CALCULATE ( COUNTA ( Table[product] ), Table[product] = "lemon" ) == 0, "0.00%",
            "-"
        )
)