Different KPIs on the same table

[gvialetto_kv]

Dear community,

I recently faced this problem and I would like to discuss the easier way to manage it. Here I attach the example

Data are defined in Table1, each row is unique and each row has a type. I need to define on the dashboard on a table different KPIs on row and each KPI is defined differently (see Table 2).

Does anyone have useful suggestion to perform it on PowerBI?

[amitchandak · Accepted solution]

@gvialetto_kv , Create  new measures like

KPI 1 = divide(calculate(sum(table[value]),table[Type] ="A"),calculate(sum(table[value]),table[Type] ="B"))
KPI 2 = divide(calculate(sum(table[value]),table[Type] ="G"),calculate(sum(table[value]),table[Type] ="I"))
KPI 3 = divide(calculate(sum(table[value]),table[Type] ="H"),calculate(sum(table[value]),table[Type] ="E") - calculate(sum(table[value]),table[Type] ="F"))

You can have a new table like given below

new Table=
union (summarize(Table, "KPI", "Value",[KPI 1] ,"KPI Def" , "A/B"),
summarize(Table, "KPI", "Value",[KPI 2] ,"KPI Def" , "H/I")
summarize(Table, "KPI", "Value",[KPI 3] ,"KPI Def" , "H/E-F"))

Or Display in a Matrix with Show Values on Rows

https://www.burningsuit.co.uk/blog/2019/04/7-secrets-of-the-matrix-visual/

[gvialetto_kv]

@amitchandak thank you for your quick reply!